The Notion Formula Cheat Sheet

and()

Tests whether the returned values of two expressions are true. Returns a boolean.

Example

and( 2 == 2, 2 == 3 )
→ false

Argument 1

The first comparison expression, which must evaluate to a boolean value.

Argument 2

The second comparison expression, which must return a boolean value.

empty()

Tests whether the argument is empty. Returns a boolean.

Example

empty( "Word" )
→ false

Argument 1

The expression to test, which can evaluate to any value type, e.g., a number, text string or date.

equal()

Tests whether the returned values of two expressions are equal. Returns a boolean.

Example

equal( 2, 3 )
→ false

Operator Equivalent

[expression] == [expression]

Argument 1

The first expression, which can evaluate to any value type, e.g., a number, text string or date.

Argument 2

The second expression. Its value type must match the value type of the first expression.

if()

Tests whether the first expression returns true. If so, it evaluates the second expression. If the first expressions returns false, it evaluates the third expression. The output type depends on your inputs.

Example

if( 4 == 5, "Equal", "Unequal" )
→ "Unequal"

Operator Equivalent

[comparison] ? [expression if true] : [expression if false]

Argument 1

The expression that evaluates to true or false.

Argument 2

The expression to evaluate if the first expression is true.

Argument 3

The expression to evaluate if the first expression is false.

larger()

Tests whether the first expression returns a larger value than the second expression. Returns a boolean.

Example

larger( "Mississippi", "Ohio" )
→ true

Operator Equivalent

[expression] > [expression]

Argument 1

The first expression, which can evaluate to any value type, e.g., a number, text string or date.

Argument 2

The expression against which to compare the first. Its value type must match the value type of the first expression.

largerEq()

Tests whether the returned value of the first expression is larger than, or equal to, the returned value of the second expression. Returns a boolean.

Example

largerEq( "Mississippi", "Ohio" )
→ true

Operator Equivalent

[expression] >= [expression]

Argument 1

The first expression, which can evaluate to any value type, e.g., a number, text string or date.

Argument 2

The expression against which to compare the first. Its value type must match the value type of the first expression.

not()

Tests whether the expression returns false. Returns a boolean.

Example

not( 2 == 2 )
→ false

Argument 1

The expression to test, which must evaluate to a boolean value.

or()

Test whether one or both expressions return true. Returns a boolean.

Example

or( 2 == 2, 1 == 3 )
→ true

Argument 1

The first comparison expression, which must evaluate to a boolean value.

Argument 2

The second comparison expression, which must return a boolean value.

smaller()

Tests whether the returned value of the first expression is smaller than the returned value of the second expression. Returns a boolean.

Example

smaller( "Mississippi", "Ohio" )
→ false

Operator Equivalent

[expression] < [expression]

Argument 1

The first expression, which can evaluate to any value type, e.g., a number, text string or date.

Argument 2

The expression against which to compare the first. Its value type must match the value type of the first expression.

smallerEq()

Tests whether the returned value of the first expression is smaller than, or equal to, the returned value of the second expression. Returns a boolean.

Example

smallerEq( "Mississippi", "Ohio" )
→ false

Operator Equivalent

[expression] <= [expression]

Argument 1

The first expression, which can evaluate to any value type, e.g., a number, text string or date.

Argument 2

The expression against which to compare the first. Its value type must match the value type of the first expression.

unequal()

Tests whether the returned values of two expressions are unequal. Returns a boolean.

Example

unequal( 2, 3 )
→ true

Operator Equivalent

[expression] != [expression]

Argument 1

The first expression, which can evaluate to any value type, e.g., a number, text string or date.

Argument 2

The second expression. Its value type must match the value type of the first expression.

abs()

Returns the absolute value of a number. Returns a number.

Example

abs( -4 )
→ 4

Argument 1

The number for which to return the absolute value.

add()

Adds two numbers. Returns a number.

Example

add( 2, 3 )
→ 5

Operator Equivalent

[number] + [number]

Argument 1

The first number in the addition expression.

Argument 2

The second number in the addition expression.

cbrt()

Returns the cube root of a number. Returns a number.

Example

cbrt( 8 )
→ 2

Argument 1

The number for which to return the cube root.

ceil()

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

Example

ceil( 4.2 )
→ 5

Argument 1

The number for which to return the ceiling integer.

divide()

Divides two numbers. Returns a number.

Example

divide( 21, 7 )
→ 3

Operator Equivalent

[number] / [number]

Argument 1

number: The dividend.

Argument 2

number: The divisor.

exp()

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

Example

exp( 2 )
→ 7.389056098931

Argument 1

The number to serve as the exponent for E.

floor()

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

Example

floor( 4.2 )
→ 4

Argument 1

The number for which to return the ceiling integer.

ln()

Returns the natural logarithm of a number. Returns a number.

Example

ln( 3 )
→ 1.098612288668

Argument 1

The number for which to return the natural logarithm.

log10()

Returns the base 10 logarithm of a number. Returns a number.

Example

log10( 100 )
→ 2

Argument 1

The number for which to return the base 10 logarithm.

log2()

Returns the base 2 logarithm of a number. Returns a number.

Example

log2( 8 )
→ 3

Argument 1

The number for which to return the base 2 logarithm.

max()

Returns the largest number from a list, where numbers are separated by commas. Returns a number.

Example

max( 2, 5, 14, 8 )
→ 14

Arguments

A list of numbers separated by commas.

min()

Returns the smallest number from a list, where numbers are separated by commas. Returns a number.

Example

min( 2, 5, 14, 8 )
→ 2

Arguments

A list of numbers separated by commas.

mod()

Divides two numbers and returns their remainder. Returns a number.

Example

mod( 3, 2 )
→ 1

Operator Equivalent

[number] % [number]

Argument 1

number: The dividend.

Argument 2

number: The divisor.

multiply()

Multiplies two numbers. Returns a number.

Example

multiply( 2, 3 )
→ 6

Operator Equivalent

[number] * [number]

Argument 1

The first number in the multiplication expression.

Argument 2

The second number in the multiplication expression.

pow()

Returns base to the exponent power. Returns a number.

Example

pow( 2, 3 )
→ 8

Operator Equivalent

[number] ^ [number]

Argument 1

number: The base.

Argument 2

number: The exponent.

round()

Rounds a number to the nearest integer. Returns a number.

Example

round( 3.2 )
→ 3

Argument 1

The number to round.

sign()

Returns the sign of a number, indicating whether it's positive (1), negative (-1) or zero (0). Returns a number.

Example

sign( 2 )
→ 1

Argument 1

The number for which to return the sign.

sqrt()

Returns the square root of a number. Returns a number.

Example

sqrt( 16 )
→ 4

Argument 1

The number for which to return the square root.

subtract()

Subtracts the second number from the first number. Returns a number.

Example

subtract( 4, 2 )
→ 2

Operator Equivalent

[number] - [number]

Argument 1

The first number in the subtraction expression.

Argument 2

The second number in the subtraction expression.

toNumber()

Converts a string, boolean or date to its corresponding number. Returns a number.

Example

toNumber( "4" )
→ 4

Argument 1

The string, boolean or date to convert.

unaryMinus()

Converts a negative number to positive, or a positive number to negative. Returns a number.

Example

unaryMinus( -2 )
→ 2

Operator Equivalent

[number] * -1

Argument 1

The number to convert.

unaryPlus()

Converts a string, boolean or date to its corresponding number. (Also see toNumber().) Returns a number.

Example

unaryPlus( "4" )
→ 4

Argument 1

The text string, boolean or date to convert.

concat()

Concatenates (combines) text strings. Returns a text string.

Example

concat( "My hometown is ", "Chapel Hill", "." )
→ "My hometown is Chapel Hill."

Operator Equivalent

[string] + [string] + [string]...

Arguments

The text strings to concatenate.

contains()

Tests whether a text string contains another text string. Returns a boolean.

Example

contains( "William Nutt", "Nutt" )
→ true

Argument 1

The text string to search.

Argument 2

The text string that may or may not fall within the first string.

format()

Converts a number, date or boolean to a text string. Returns a text string.

Example

format( 3 )
→ "3"

Argument 1

The number, date or boolean to convert.

join()

Combines text strings, with a specified delimiter. Returns a text string.

Example

join( ", ", "Sally", "Chris", "Adam" )
→ "Sally, Chris, Adam"

Arguments

The first argument is the delimiter, a text string. The remaining arguments are the text strings to combine using the delimiter.

length()

Returns the number of characters in a text string. Returns a number.

Example

length( "New York City" )
→ 13

Argument 1

The text string for which to return the length.

replace()

Replaces the first regular expression match within a text string with a specified new text string. Returns a text string.

Example

replace( "My name is William.", "(?<=is ).+(?=\.)", "Alex")
→ "My name is Alex."

Argument 1

The original text string.

Argument 2

The regular expression (within double quotes).

Argument 3

The replacement text string.

replaceAll()

Replaces all regular expression matches within a text string with a specified new text string. Returns a text string.

Example

replaceAll( "I like boats. I like sunshine. I like summer.", "like", "love" )
→ "I love boats. I love sunshine. I love summer."

Argument 1

The original text string.

Argument 2

The regular expression (within double quotes).

Argument 3

The replacement text string.

slice()

Extracts a substring from a text string, given a specified starting point and optional end point. Returns a text string.

Example

slice( "Yellow, Green, Blue, Red", 8, 19 )
→ Green, Blue

Argument 1

The original text string.

Argument 2

The index of the original text string where the new text string begins. Indexing begins at 0.

Argument 3

[Optional] The index of the original text string before which the new text string should end. Indexing begins at 0.

test()

Tests whether a text string matches a regular expression. Returns a boolean.

Example

test( "California, Florida, Texas", "Florida" )
→ true

Argument 1

The text string within which to find matches.

Argument 2

The regular expression.

date()

Returns the day of the month — an integer (number) between 1 and 31 — for a given date. Returns a number.

Example

date( now() )
→ 22

Argument 1

The date from which to identify the day of the month.

dateAdd()

Adds time to a date. Returns a date.

Example

dateAdd( now(), 1, "months" )
→ Mar 23, 2020 11:15 AM

Argument 1

The starting date.

Argument 2

number: The amount to add.

Argument 3

The unit of time, which can be years, quarters, months, weeks, days, hours, minutes, seconds, milliseconds. Wrap it in double quotes.

dateBetween()

Returns the amount of time between two dates. Returns a number.

Example

dateBetween( now(), prop("Created Time"), "minutes" )
→ 43

Argument 1

The later date.

Argument 2

The earlier date.

Argument 3

The unit of time for the returned value, which can be years, quarters, months, weeks, days, hours, minutes, seconds, milliseconds. Wrap it in double quotes.

dateSubtract()

Subtracts time from a date. Returns a date.

Example

dateSubtract( now(), 1, "months" )
→ Jan 23, 2020 11:15 AM

Argument 1

The starting date.

Argument 2

number: The amount to subtract.

Argument 3

The unit of time, which can be years, quarters, months, weeks, days, hours, minutes, seconds, milliseconds. Wrap it in double quotes.

day()

Returns the index (number) of the day of the week for a date, where Sunday is 0, Monday is 1, and so forth. Returns a number.

Example

day( now() )
→ 2

Argument 1

The date for which to identify the day of the week.

end()

Returns the end date from a Date property containing a date range. Returns a date.

Example

end( prop("Duration") )
→ Feb 27, 2020

Argument 1

A reference to a Date property containing an end date.

formatDate()

Transforms a date into virtually any format using a Moment JS string. Returns a string.

Example

formatDate( now(), "h:mm A on dddd, MMMM DD, YYYY")
→ 1:50 PM on Sunday, February 23, 2020

fromTimestamp()

Returns a date value from a Unix millisecond timestamp, or the number of milliseconds since January 1, 1970. Returns a date.

Example

fromTimestamp( 1582479120000 )
→ Feb 23, 2020 12:32 PM

Argument 1

A number representing a Unix millisecond timestamp, or the number of milliseconds since January 1, 1970.

hour()

Returns the hour of the day — an integer (number) between 0 and 23 — for a date value. Returns a number.

Example

hour( now() )
→ 13

Argument 1

The date value for which to identify the hour of the day.

minute()

Returns the minute of the hour — an integer (number) between 0 and 59 — for a date value. Returns a number.

Example

minute( now() )
→ 24

Argument 1

The date value for which to identify the minute of the hour.

month()

Returns the index (number) of the month of the year for a date, where January is 0, February is 1, and so forth. Returns a number.

Example

month( now() )
→ 3

Argument 1

The date value for which to identify the month of the year.

now()

Returns a date that remains current. Returns a date.

Example

now()
→ Feb 23, 2020 12:35 PM

start()

Returns the start date from a Date property containing a date range. Returns a date.

Example

start( prop("Duration") )
→ Jan 27, 2020

Argument 1

A reference to a Date property containing an end date.

timestamp()

Returns the Unix millisecond timestamp for a date, or the number of milliseconds since January 1, 1970. Returns a number.

Example

timestamp( now() )
→ 1582479120000

Argument 1

The date value from which to obtain the timestamp.

year()

Returns the year for a date. Returns a number.

Example

year( now() )
→ 2020

Argument 1

The date for which to identify the year.