Functions

String

concat

join

slice

format

replace

replaceAll

formatDate

Boolean

contains

test

empty

Date

start

end

now

fromtTimestamp

dateAdd

dateSubtract

Number

length

toNumber

abs

cbrt

ceil

exp

floor

log10

log2

max

min

round

sign

sqrt

timestamp

dateBetween

minute

hour

day

date

month

year

Operators

add

subtract

multiply

divide

pow

mod

unaryMinus

unaryPlus

not

and

equal

unequal

larger

largerEq

smaller

smallerEq

Constants

true

false

Name of Function( )

-Notion's description of function.

Explanation

💡

A further explanation of how the function functions.

Requires: # of Arguments

Type of Argument
Type of Argument

Returns: Type of returned Value

Syntax

Possible variances of the function

Examples

a function example and operator example if applicable.

Syntax	Return
the actual code entered in the formula.	what the formula spits out

\Huge \colorbox{red}{Functions}

concat( )

-Concatenates its arguments and returns the result.

Explanation

💡

Concatenate means "to combine". This function combines text Strings together.

Requires: 2+ Arguments

2+ Strings

Returns: String

Syntax

concat(text...)

Examples

"dog" +"go" == "doggo"
concat("dog", "go") == "doggo"

Syntax	Return
concat("dog", "go" )	doggo

join( )

-Inserts the first argument between the rest and returns their concatenation.

Explanation

💡

Joins the first argument in between the rest of the arguments. The first argument is called a delimiter.

Requires: 3+ Arguments

1 Delimiter String
2+ Strings

Returns: String

Syntax

join(text...)

Examples

join("-", "a", "b", "c") == "a-b-c"

Syntax	Return
join("-", "a", "b", "c")	a-b-c

slice( )

-Extracts a substring from a string from the start index (inclusively) to the end index (optional and exclusively).

Explanation

💡

Requires:

Returns:

Syntax

slice(text, number)
slice(text, number, number)

Examples

slice("Hello world", 1, 5) == "ello"
slice("notion", 3) == "ion"

Syntax	Return
slice("Hello world", 1, 5)	ello

length( )

-Returns the length of a string.

Explanation

💡

Returns a number signifying how many characters are included in the given string.

Requires: 1 Argument

1 String

Returns: Number

Syntax

length(text)

Examples

length("Hello world") == 11

Syntax	Return
length("Hello world")	11

format( )

-Formats its argument as a string.

Explanation

💡

Turns non-string values into strings. 42 is a number but an actual number justifies to the right of the cell while a string justifies left. You can tell the 42 in the example is a string because of this.

Requires: 1 Argument

1 Number, Date, or Boolean

Returns: String

Syntax

format(value)

Examples

format(42) == "42"
format(true) == "true"
format(now()) == "Wed Dec 31 1969 16:00:00 GMT-0800 (PST)"

Syntax	Return
format(42)	42

toNumber( )

-Parses a number from text.

Explanation

💡

Turns non-number values into numbers. 42 is a number and an actual number justifies to the right of the cell while a string justifies left. You can tell the 42 in the example is a number because of this.

Requires:

1 String, Number, Boolean, or Date

Returns: Number

Syntax

toNumber(text)
toNumber(number)
toNumber(boolean)
toNumber(date)

Examples

toNumber("42") == 42
toNumber(false) == 0

Syntax	Return
toNumber("42")	42

contains( )

-Returns true if the second argument is found in the first.

Explanation

💡

Checks to see if the first argument contains the second argument. Now we can finally answer the question - is there a "I" in "TEAM"?

Requires: 2 Arguments

1 String to search from
1 String to search for

Returns: Boolean

Syntax

contains(text, text)

Examples

contains("notion", "ion") == true

Syntax	Return
contains("notion", "ion")

replace( )

-Replaces the first match of a regular expression with a new value.

Explanation

💡

The first argument is the value to search. The second argument signifies what character to search for and replace. By entering a simple character, it will replace only the first occurrence of that character, but Regex can get very complex. click the link for more info. The third argument is the string that will replace what the second argument finds.

Requires: 3 Arguments

1 Number, String, or Boolean
1 Regular Expression (wikipedia)
1 Replacement String

Returns: String

Syntax

replace(number, text, text)
replace(text, text, text)
replace(boolean, text, text)

Examples

replace("1-2-3", "-", "!") == "1!2-3"

Syntax	Return
replace("1-2-3", "-", "!")	1!2!3

replaceAll( )

-Replaces all matches of a regular expression with a new value.

Explanation

💡

The first argument is the value to search. The second argument signifies what character to search for and replace. By entering a simple character, it will replace all matches of that character, but Regex can get very complex. click the link for more info. The third argument is the string that will replace what the second argument finds.

Requires: 3 Arguments

1 Number, String, or Boolean
1 Regular Expression (wikipedia)
1 Replacement String

Returns: String

Syntax

replaceAll(number, text, text)
replaceAll(text, text, text)
replaceAll(boolean, text, text)

Examples

replaceAll("1-2-3", "-", "!") == "1!2!3"

Syntax	Return
replaceAll("1-2-3", "-", "!")	1!2!3

test( )

-Tests if a string matches a regular expression.

Explanation

💡

Checks if the first argument contains the second argument. The second argument can be a simple character or a more complex Regular Expression.

Requires: 2 Arguments

1 Number, String, or Boolean
1 Regular Expression (wikipedia)

Returns: Boolean

Syntax

test(number, text)
test(text, text)
test(boolean, text)

Examples

test("1-2-3", "-") == true

Syntax	Return
test("1-2-3", "-")

empty( )

-Tests if a value is empty.

Explanation

💡

If nothing is contained in the value it is the function of, then it returns a true boolean value.

Requires: 1 Argument

1 Number, String, Boolean, or Date

Returns: Boolean

Syntax

empty(number)
empty(text)
empty(boolean)
empty(date)

Examples

empty("") == true

Syntax	Return
empty("")

abs( )

-Returns the absolute value of a number.

Explanation

💡

The absolute value of a number is its distance from 0, whether positive or negative. Can take a positive or negative number but will always return a positive number.

Requires: 1 Argument

1 Number

Returns: Number

Syntax

abs(number)

Examples

abs(-3) == 3

Syntax	Return
abs(-3)	3

cbrt( )

-Returns the cube root of a number.

Explanation

💡

Returns the cube root of the number given in the argument.

Requires: 1 Argument

1 Number

Returns: Number

Syntax

cbrt(number)

Examples

cbrt(8) == 2

Syntax	Return
cbrt(8)	2

ceil( )

-Returns the smallest integer greater than or equal to a number.

Explanation

💡

Short for ceiling, this function gives you the next highest number above any number with a decimal. 4.0001 turns to 5 because it's greater than 4, but 4 remains 4.

Requires: 1 Argument

1 Number

Returns: Number

Syntax

ceil(number)

Examples

ceil(4.2) == 5

Syntax	Return
ceil(4.2)	5

exp( )

-Returns E^x, where x is the argument, and E is Euler's constant (2.718…), the base of the natural logarithm.

Explanation

💡

Multiples the argument by Euler's constant.

Requires: 1 Argument

1 Number

Returns: Number

Syntax

exp(number)

Examples

exp(1) == 2.718281828459045

Syntax	Return
exp(1)	2.718281828459045

floor( )

-Returns the largest integer less than or equal to a number.

Explanation

💡

This function gives you the next lowest number below any number with a decimal. 2.999 turns to 2 because it's less than 3, but 3 remains 3.

Requires: 1 Argument

1 Number

Returns: Number

Syntax

floor(number)

Examples

floor(2.8) == 2

Syntax	Return
floor(2.8)	2

ln( )

-Returns the natural logarithm of a number.

Explanation

💡

math 🤷🏼‍♂️

Requires: 1 Argument

1 Number

Returns: Number

Syntax

ln(number)

Examples

ln(e) == 1

Syntax	Return
ln(e)	-Infinity

log10( )

-Returns the base 10 logarithm of a number.

Explanation

💡

Math 🤷🏼‍♂️

Requires: 1 Argument

1 Number

Returns: Number

Syntax

log10(number)

Examples

log10(1000) == 3

Syntax	Return
log10(1000)	3

log2( )

-Returns the base 2 logarithm of a number.

Explanation

💡

math 🤷🏼‍♂️

Requires: 1 Argument

1 Number

Returns: Number

Syntax

log2(number)

Examples

log2(64) == 6

Syntax	Return
log2(64)	6

max( )

-Returns the largest of zero or more numbers.

Explanation

💡

Gives you the largest number in a set of numbers.

Requires: 1+ Argument

1+ Number

Returns: Number

Syntax

max(number...)

Examples

max(5, 2, 9, 3) == 9

Syntax	Return
max(5, 2, 9, 3)	9

min( )

-Returns the smallest of zero or more numbers.

Explanation

💡

Gives you the smallest number in a set of numbers.

Requires: 1+ Argument

1+ Number

Returns: Number

Syntax

min(number...)

Examples

min(4, 1, 5, 3) == 1

Syntax	Return
min(4, 1, 5, 3)	1

round( )

-Returns the value of a number rounded to the nearest integer.

Explanation

💡

Rounds a number with a decimal up or down. 4.49999 rounds down to 4 while 4.5 rounds up to 5.

Requires: 1 Argument

1 Number

Returns: Number

Syntax

round(number)

Examples

round(4.4) == 4
round(4.5) == 5

Syntax	Return
round(4.4)	4
round(4.5)	5

sign( )

-Returns the sign of the x, indicating whether x is positive, negative or zero.

Explanation

💡

A ternary code that returns 1 for a positive number, -1 for a negative number, and 0 for zero.

Requires: 1 Argument

1 Number

Returns: Number

Syntax

sign(number)

Examples

sign(4) == 1
sign(-9) == -1
sign(0) == 0

Syntax	Return
sign(4)	1
sign(-9)	-1
sign(0)	0

sqrt( )

-Returns the positive square root of a number.

Explanation

💡

Gives the number that, when multiplied by itself, would equal the number provided.

Requires: 1 Argument

1 Number

Returns: Number

Syntax

sqrt(number)

Examples

sqrt(144) == 12

Syntax	Return
sqrt(144)	12

start( )

-Returns the start of a date range.

Explanation

💡

Date properties can have a start and end date. This returns the start date, or if there is no end date, the original date entry.

Requires: 1 Argument

1 Date

Returns: Date

Syntax

start(date)

Examples

start(prop("Date")) == Feb 2, 1996

Syntax	Date	Return
start(prop("Date"))	June 22, 2021	June 22, 2021 12:00 AM2023-03-26T21:56:18+00:00
start(prop("Date"))	June 22, 2021 → June 26, 2021	June 22, 2021 12:00 AM2023-03-26T21:56:18+00:00
start(prop("Date"))	June 22, 2021 1:00 PM (CDT) → June 26, 2021 5:00 PM (CDT)	June 22, 2021 1:00 PM2023-03-26T21:56:18+00:00

end( )

-Returns the end of a date range.

Explanation

💡

Date properties can have a start and end date. This returns the end date, or if there is no end date, the original date entry.

Requires: 1 Argument

1 Date

Returns: Date

Syntax

end(date)

Examples

end(prop("Date")) == Feb 2, 1996

Syntax	Date	Return
end(prop("Date"))	June 22, 2021 → June 23, 2021	June 23, 2021 12:00 AM2023-03-26T21:56:18+00:00

now( )

-Returns the current date and time.

Explanation

💡

Gives the current date and time down to the minute. Notion currently does not track seconds in the Date value type.

Requires: 0 Arguments

Time exists

Returns: Date

Syntax

now()

Examples

now() == Feb 2, 1996

Syntax	Return
now()	March 20, 2023 11:58 AM2023-03-26T21:56:18+00:00

timestamp( )

-Returns an integer number from a Unix millisecond timestamp, corresponding to the number of milliseconds since January 1, 1970.

Explanation

💡

Literally gives you the number of milliseconds since January 1, 1970. Refresh the page and you'll see it change.

Requires: 1 Argument

1 Date

Returns: Number

Syntax

timestamp(date)

Examples

timestamp(now()) == 1512593154718

Syntax	Return
timestamp(now())	1679313498414

fromTimestamp

-Returns a date constructed from a Unix millisecond timestamp, corresponding to the number of milliseconds since January 1, 1970.

Explanation

💡

What day/time would it be after 1,000,000,000,000 (1 trillion) milliseconds, starting from January 1, 1970? Check the example.

Requires: 1 Argument

1 Number

Returns: Date

Syntax

fromTimestamp(number)

Examples

fromTimestamp(2000000000000) == Tue May 17 2033

Syntax	Return
fromTimestamp(1000000000000)	September 9, 2001 1:46 AM2023-03-26T21:56:18+00:00

dateAdd

-Add to a date. The last argument, unit, can be one of: "years", "quarters", "months", "weeks", "days", "hours", "minutes", "seconds", or "milliseconds".

Explanation

💡

Adds a specified amount of time to a given Date.

Requires: 3 Arguments

1 Date
1 Number
1 String

Returns: Date

Syntax

dateAdd(date, number, text)

Examples

dateAdd(date, amount, "years")
dateAdd(date, amount, "quarters")
dateAdd(date, amount, "months")
dateAdd(date, amount, "weeks")
dateAdd(date, amount, "days")
dateAdd(date, amount, "hours")
dateAdd(date, amount, "minutes")
dateAdd(date, amount, "seconds")
dateAdd(date, amount, "milliseconds")

Syntax	Date	Return
dateAdd(prop("Date"), 10, "years")	June 22, 2021	June 22, 2031 12:00 AM2023-03-26T21:56:18+00:00

dateSubtract( )

-Subtract from a date. The last argument, unit, can be one of: "years", "quarters", "months", "weeks", "days", "hours", "minutes", "seconds", or "milliseconds".

Explanation

💡

Subtracts a specified amount of time from a given Date.

Requires: 3 Arguments

1 Date
1 Number
String

Returns: Date

Syntax

dateSubtract(date, number, text)

Examples

dateSubtract(date, amount, "years")
dateSubtract(date, amount, "quarters")
dateSubtract(date, amount, "months")
dateSubtract(date, amount, "weeks")
dateSubtract(date, amount, "days")
dateSubtract(date, amount, "hours")
dateSubtract(date, amount, "minutes")
dateSubtract(date, amount, "seconds")
dateSubtract(date, amount, "milliseconds")

Syntax	Date	Return
dateSubtract(prop("Date"), 10, "years")	June 22, 2021	June 22, 2011 12:00 AM2023-03-26T21:56:18+00:00

dateBetween( )

-Returns the time between two dates. The last argument, unit, can be one of: "years", "quarters", "months", "weeks", "days", "hours", "minutes", "seconds", or "milliseconds".

Explanation

💡

Specify the unit of time and measure the distance between two Dates by that unit. How do you measure, measure a year?

Requires: 3 Arguments

2 Dates
1 String

Returns: Number

Syntax

dateBetween(date, date, text)

Examples

dateBetween(date, date2, "years")
dateBetween(date, date2, "quarters")
dateBetween(date, date2, "months")
dateBetween(date, date2, "weeks")
dateBetween(date, date2, "days")
dateBetween(date, date2, "hours")
dateBetween(date, date2, "minutes")
dateBetween(date, date2, "seconds")
dateBetween(date, date2, "milliseconds")

Syntax	Date 1	Date 2	Return
dateBetween(prop("Date 2"), prop("Date 1"), "minutes")	June 22, 2021	June 22, 2022	525600

formatDate( )

-Format a date using the Moment standard time format string.

Explanation

💡

Transform a Date into any customized format. Uses Moment.js formatting. Important: returns a String, not a Date.

Requires: 2 Arguments

1 Date
1 String

Returns: String

Syntax

formatDate(date, text)

Examples

formatDate(now(), "MMMM D YYYY, HH:mm") == March 30 2010, 12:00
formatDate(now(), "YYYY/MM/DD, HH:mm") == 2010/03/30, 12:00
formatDate(now(), "MM/DD/YYYY, HH:mm") == 03/30/2010, 12:00
formatDate(now(), "HH:mm A") == 12:00 PM
formatDate(now(), "M/D/YY") == 3/30/10

Syntax	Date	Return
formatDate(prop("Date"), "MMMM D YYYY, HH:mm")	June 22, 2021	June 22 2021, 00:00

minute( )

-Returns an integer number, between 0 and 59, corresponding to minutes in the given date.

Explanation

💡

Gives the minute of the given Date. If the Date shows 12:37pm, the formula returns the number 37.

Requires: 1 Argument

1 Date

Returns: Number

Syntax

minute(date)

Examples

minute(now()) == 45

Syntax	Return
minute(now())	58

hour( )

-Returns an integer number, between 0 and 23, corresponding to hour for the given date.

Explanation

💡

Gives the hour of the given Date. If the Date shows 12:37pm, the formula returns the number 12.

Requires: 1 Argument

1 Date

Returns: Number

Syntax

hour(date)

Examples

hour(now()) == 17

Syntax	Return
hour(now())	11

day( )

-Returns an integer number corresponding to the day of the week for the given date: 0 for Sunday, 1 for Monday, 2 for Tuesday, and so on.

Explanation

💡

Gives a number for the day of the week. 0: Sunday 1: Monday 2: Tuesday 3: Wednesday 4: Thursday 5: Friday 6: Saturday

Requires: 1 Argument

1 Date

Returns: Number

Syntax

day(date)

Examples

day(now()) == 3

Syntax	Return
day(now())	1

date( )

-Returns an integer number, between 1 and 31, corresponding to day of the month for the given.

Explanation

💡

Gives the Calendar day number of the month, 1-31.

Requires: 1 Argument

1 Date

Returns: Number

Syntax

date(date)

Examples

date(now()) == 13

Syntax	Return
date(now())	20

month( )

-Returns an integer number, between 0 and 11, corresponding to month in the given date according to local time. 0 corresponds to January, 1 to February, and so on.

Explanation

💡

Gives the number for the month in the date. Important: Starts with January at 0 so it is NOT the same number as the calendar number.

Requires: 1 Argument

1 Date

Returns: Number

Syntax

month(date)

Examples

month(now()) == 11

Syntax	Date	Return
month(prop("Date"))	June 22, 2021	5

year( )

-Returns a number corresponding to the year of the given date.

Explanation

💡

Wha....What year is it?

Requires: 1 Argument

1 Date

Returns: Number

Syntax

year(date)

Examples

year(now()) == 1984

Syntax	Return
year(now())	2023

Syntax	Return
	doggo

\Huge \colorbox{red}{Operators}

if( )

-Switches between two options based on another value.

Explanation

💡

The 1st argument is a boolean - either true or false. If it's true, the 2nd argument is returned, if it's false, the 3rd argument is returned.

Requires: 3 Arguments

1 Boolean
2 Values

Returns: Value

Syntax

boolean ? value : value
if(boolean, value, value)

Examples

true ? 1 : -1 == 1
if(false, "yes", "no") == "no"

Syntax	Number	Return
if(prop("Number") > 5, "yes", "no")	1	no
	10	yes

add( )

-Adds two numbers and returns their sum, or concatenates two strings.

Explanation

💡

Simple addition of two numbers OR it can act the same as the concat() function, combining two strings.

Requires: 2 Arguments

2 Numbers OR
2 Strings

Returns: Number OR String

Syntax

number + number
text + text
add(number, number)
add(text, text)

Examples

3 + 4 = 7
add(1, 3) == 4
"add" + "text" == "addtext"

Syntax	Return
add(1, 1)	2
1 + 5	6

Syntax	Return	Function Return	Operator Return	Operator/Function
add(1, 1)	2	2	6	Function
1 + 5	6	2	6	Operator

subtract( )

-Subtracts two numbers and returns their difference.

Explanation

💡

Requires:

Returns:

Syntax

number - number
subtract(number, number)

Examples

3 - 1 == 2
subtract(4, 5) == -1

Syntax	Return
	doggo

multiply( )

-Multiplies two numbers and returns their product.

Explanation

💡

Requires:

Returns:

Syntax

number * number
multiply(number, number)

Examples

6 * 9 == 54
multiply(2, 10) == 20

Syntax	Return
	doggo

divide( )

-Divides two numbers and returns their quotient.

Explanation

💡

Requires:

Returns:

Syntax

number / number
divide(number, number)

Examples

12 / 4 == 3
divide(12, 3) == 4

Syntax	Return
	doggo

pow( )

-Returns base to the exponent power, that is, baseexponent.

Explanation

💡

Requires:

Returns:

Syntax

number ^ number
pow(number, number)

Examples

5 ^ 3 == 125
pow(2, 6) == 64

Syntax	Return
	doggo

mod( )

-Divides two numbers and returns their remainder.

Explanation

💡

Requires:

Returns:

Syntax

number % number
mod(number, number)

Examples

7 % 5 == 2
mod(3, 3) == 0

Syntax	Return
	doggo

unaryMinus( )

-Negates a number.

Explanation

💡

Requires:

Returns:

Syntax

- number
unaryMinus(number)

Examples

-1 + 2 == 1
unaryMinus(42) == -42

Syntax	Return
	doggo

unaryPlus( )

-Converts its argument into a number.

Explanation

💡

Requires:

Returns:

Syntax

+ value
unaryPlus(value)

Examples

+ "42" == 42
unaryPlus(true) == 1

Syntax	Return
	doggo

not( )

-Returns the logical NOT of its argument.

Explanation

💡

Requires:

Returns:

Syntax

not boolean
not(boolean)

Examples

not true == false
not(false) == true

Syntax	Return
	doggo

and( )

-Returns the logical AND of its two arguments.

Explanation

💡

Requires:

Returns:

Syntax

boolean and boolean
and(boolean, boolean)

Examples

true and false == false
and(true, true) == true

Syntax	Return
	doggo

or( )

-Returns the logical OR of its two arguments.

Explanation

💡

Requires:

Returns:

Syntax

boolean or boolean
or(boolean, boolean)

Examples

false or true == true
or(false, false) == false

Syntax	Return
	doggo

equal( )

-Returns true if its arguments are equal, and false otherwise.

Explanation

💡

Requires:

Returns:

Syntax

value == value
equal(value, value)

Examples

(3 * 5 == 15) == true
equal(false, not true) == true

Syntax	Return
	doggo

unequal( )

-Returns false if its arguments are equal, and true otherwise.

Explanation

💡

Requires:

Returns:

Syntax

value != value
unequal(value, value)

Examples

(6 * 9 != 42) == false
(true != not false) == false

Syntax	Return
	doggo

larger( )

-Returns true if the first argument is larger than the second.

Explanation

💡

Requires:

Returns:

Syntax

text > text
boolean > boolean
date > date
number > number
larger(text, text)
larger(boolean, boolean)
larger(date, date)
larger(number, number)

Examples

5 > 3 == true

Syntax	Return
	doggo

largerEq( )

-Returns true if the first argument is larger than or equal to than the second.

Explanation

💡

Requires:

Returns:

Syntax

text >= text
boolean >= boolean
date >= date
number >= number
largerEq(text, text)
largerEq(boolean, boolean)
largerEq(date, date)
largerEq(number, number)

Examples

5 >= 3 == true
4 >= 4 == true

Syntax	Return
	doggo

smaller( )

-Returns true if the first argument is smaller than the second.

Explanation

💡

Requires:

Returns:

Syntax

text < text
boolean < boolean
date < date
number < number
smaller(text, text)
smaller(boolean, boolean)
smaller(date, date)
smaller(number, number)

Examples

10 < 8 == false

Syntax	Return
	doggo

smallerEq( )

-Returns true if the first argument is smaller than or equal to than the second.

Explanation

💡

Requires:

Returns:

Syntax

text <= text
boolean <= boolean
date <= date
number <= number
smallerEq(text, text)
smallerEq(boolean, boolean)
smallerEq(date, date)
smallerEq(number, number)

Examples

10 <= 8 == false
8 <= 8 == true

Syntax	Return
	doggo

\Huge \colorbox{red}{Constants}

e

-The base of the natural logarithm.

Explanation

💡

Requires:

Returns:

Syntax

Examples

e == 2.718281828459045

Syntax	Return
	doggo

pi

-The ratio of a circle's circumference to its diameter.

Explanation

💡

Requires:

Returns:

Syntax

pi

Examples

2 * pi == 6.283185307179586

Syntax	Return
	doggo

true

Explanation

💡

Requires:

Returns:

Syntax

true

Examples

true ? "yes" : "no" == "yes"

Syntax	Return
	doggo

false

Explanation

💡

Requires:

Returns:

Syntax

false

Examples

false ? "yes" : "no" == "no"

Syntax	Return
	doggo

prop

abs

cbrt

ceil

concat

contains

date

dateAdd

dateBetween

dateSubtract

day

empty

end

exp

floor

format

formateDate

fromTimestamp

hour

join

length

log10

log2

max

min

minute

month

now

replace

replaceAll

round

sign

slice

sqrt

start

test

timestamp

toNumber

year

false

true

add

and

divide

equal

larger

largerEq

mod

multiply

not

pow

smaller

smallerEq

subtract

unaryMinus

unaryPlus

unequal

Related Resources

Name	Description

Created in Notion by Josh Redd at NotionState. 🖤 Find value here? Consider buying me a coffee ☕

Formula Guide

Functions

String

Boolean

Date

Number

Operators

Constants

Name of Function( )

Example

concat( )

Example

join( )

Example

slice( )

Example

length( )

Example

format( )

Example

toNumber( )

Example

contains( )

Example

replace( )

Example

replaceAll( )

Example

test( )

Example

empty( )

Example

abs( )

Example

cbrt( )

Example

ceil( )

Example

exp( )

Example

floor( )

Example

ln( )

Example

log10( )

Example

log2( )

Example

max( )

Example

min( )

Example

round( )

Example

sign( )

Example

sqrt( )

Example

start( )

Example

end( )

Example

now( )

Example

timestamp( )

Example

fromTimestamp

Example

dateAdd

Example

dateSubtract( )

Example

dateBetween( )

Example

formatDate( )

Example

minute( )

Example

hour( )

Example