Formulas 101

‣

Function

Name	Description	Accepts	Returns	Alternative
if	Returns the first value if the condition is true; otherwise, returns the second value.	Boolean	All Data Types	? :
ifs	Returns the value that corresponds to the first true condition.	Boolean	All Data Types
and	The boolean operator and.	Boolean	Boolean	&&
or	The boolean operator or.	All Data Types	Boolean	\|\|
not	Returns the opposite of a boolean value.	Boolean	Boolean	!
empty	Returns true if the value is empty.	All Data Types	Boolean
length	Returns the length of the text or list value.	StringList	Number
substring	Returns the substring of the text from the start index to the end index.	String	String
contains	Returns true if the search string is present in the value.	String	Boolean
test	Returns true if the value matches the regular expression and false otherwise.	String	Boolean
match	Returns all matches of the regular expression as a list.	String	List
replace	Replaces the first match of the regular expression with the replacement value.	String	String
replaceAll	Replaces all matches of the regular expression with the replacement value.	String	String
lower	Converts the text to lowercase.	String	String
upper	Converts the text to uppercase.	String	String
repeat	Repeats the text a given number of times.	String	String
padStart	Returns the text padded with the provided padding string at the start until the target length is reached.	String	String
padEnd	Returns the text padded with the provided padding string at the end until the target length is reached.	String	String
link	Creates a hyperlink from the label text and the URL.	String	String
style	Adds styles and colours to the text.	String	String
unstyle	Removes formatting styles from the text.	String	String
format	Formats its argument as a string.	All Data Types	String
add	Returns the sum of two numbers.	Number	Number	+
subtract	Returns the difference of two numbers.	Number	Number	-
multiply	Returns the product of two numbers.	Number	Number	*
mod	Returns the first number modulo the second number.	Number	Number	%
pow	Returns the result of a base number raised to an exponent power.	Number	Number	^
divide	Returns the quotient of two numbers.	Number	Number	/
min	Returns the smallest number of the arguments.	NumberList	Number
max	Returns the largest number of the arguments.	NumberList	Number
sum	Returns the sum of its arguments.	NumberList	Number
median	Returns the middle value of its arguments.	ListNumber	Number
mean	Returns the arithmetic average of its arguments.	ListNumber	Number
abs	Returns the absolute value of the number.	Number	Number
round	Returns the value of a number rounded to the nearest integer.	Number	Number
ceil	Returns the smallest integer greater than or equal to the number.	Number	Number
floor	Returns the largest integer less than or equal to the number.	Number	Number
sqrt	Returns the positive square root of the number.	Number	Number
cbrt	Returns the cube root of the number.	Number	Number
exp	Returns e^x	Number	Number
ln	Returns the natural logarithm of the number.	Number	Number
log10	Returns the base 10 logarithm of the number.	Number	Number
log2	Returns the base 2 logarithm of the number.	Number	Number
sign	Returns 1 if the number is positive, -1 if it is negative, and 0 if it is zero.	Number	Number
pi	Returns the ratio of a circle's circumference to its diameter.		Number
e	Returns the base of the natural logarithm.		Number
toNumber	Parses a number from text.	StringDate	Number
now	Returns the current date and time.		Date
today	Returns the current date without the time.		Date
minute	Returns the minute of the date (0-59).	Date	Number
hour	Returns the hour of the date (0-23).	Date	Number
day	Returns the day of the week of the date, between 1 (Monday) and 7 (Sunday).	Date	Number
date	Returns the day of the month from the date (1-31).	Date	Number
week	Returns the ISO week of the year of the date (1-53).	Date	Number
month	Returns the month of the date (1-12).	Date	Number
year	Returns the year of the date.	Date	Number
dateAdd	Adds time to the date.	Date	Date
dateSubtract	Subtracts time from the date.	Date	Date
dateBetween	Returns the difference between two dates.	Date	Number
dateRange	Returns a date range constructed from the start and end dates.	Date	Date
dateStart	Returns the start of the date range.	Date	Date
dateEnd	Returns the end of the date range.	Date	Date
timestamp	Returns the current Unix timestamp.	Date	Number
fromTimestamp	Returns the date from the given Unix timestamp.	Number	Date
formatDate	Formats the date using a custom format string.	Date	String
parseDate	Returns the date parsed according to the ISO 8601 standard.	String	Date
name	Returns the name of a person.	Person	String
email	Returns the email address of a person.	Person	String
at	Returns the value at the specified index in a list.	List	All Data Types
first	Returns the first item in the list.	List	All Data Types
last	Returns the last item in the list.	List	All Data Types
slice	Returns the items of the list from the provided start index to the end index.	List	List
concat	Returns the concatenation of multiple lists.	List	List
sort	Returns the list in sorted order.	List	List
reverse	Returns the reversed list.	List	List
join	Returns the values of the list with the joiner placed between each of the values.	List	String
split	Returns the list of values created by splitting a text by a separator.	String	List
unique	Returns the list of unique values in the input list.	List	List
includes	Returns true if the list contains the specified value, and false otherwise.	List	Boolean
find	Returns the first element in the list for which the condition returns true.	List	List
findIndex	Returns the index of the first item in the list for which the condition evaluates to true.	List	Number
filter	Returns the values in the list for which the condition is true.	List	List
some	Returns true if any item in the list satisfies the given condition, and false otherwise.	List	Boolean
every	Returns true if every item in the list satisfies the given condition, and false otherwise.	List	Boolean
map	Returns the list populated with the results of calling the expression on every item in the input list.	List	List
flat	Flattens a list of lists into a single list.	List	List
id	Returns the id of the page.	Page	String
equal	Returns true if both values are equal and false otherwise.	All Data Types	Boolean	==
unequal	Returns false if both values are equal and true otherwise.	All Data Types	Boolean	!=
let	Assigns a value to a variable and evaluates the expression using that variable.	All Data Types	All Data Types
lets	Assigns values to multiple variables and evaluates the expression using those variables.	All Data Types	All Data Types

‣

Operator

Name	Description	Accepts	Returns	Alternative
+	Adds two values together.	StringNumber	StringNumber	add
-	Subtracts two numbers.	Number	Number	subtract
*	Multiplies two numbers.	Number	Number	multiply
%	Returns the first number modulo the second number.	Number	Number	mod
^	Returns the result of a base number raised to an exponent power.	Number	Number	pow
/	Divides two numbers.	Number	Number	divide
==	Checks if two values are equal.	All Data Types	Boolean	equal
!=	Checks if two values are not equal.	All Data Types	Boolean	unequal
>	Checks if the first value is greater than the second.	StringNumberBooleanDate	Boolean
>=	Checks if the first value is greater than or equal to the second.	StringNumberBooleanDate	Boolean
<	Checks if the first value is less than the second.	StringNumberBooleanDate	Boolean
<=	Checks if the first value is less than or equal to the second.	StringNumberBooleanDate	Boolean
&&	The boolean operator and.	Boolean	Boolean	and
\|\|	The boolean operator or.	Boolean	Boolean	or
!	Returns the opposite of a boolean value.	Boolean	Boolean	not
? :	The ternary operator.	Boolean	All Data Types	if

‣

Boolean

Name	Description	Accepts	Returns	Alternative
true	The boolean value true.		Boolean
false	The boolean value false.		Boolean

‣

Variable

Name	Description	Accepts	Returns	Alternative
current	Returns the value of the current item in the list function.	List	All Data Types
index	Returns the index of the current item in the list function, starting from 0.	List	Number

Name

Description

Accepts

Returns

Alternative

Returns the first value if the condition is true; otherwise, returns the second value.

Boolean

All Data Types

? :

ifs

Returns the value that corresponds to the first true condition.

Boolean

All Data Types

and

The boolean operator and.

Boolean

The boolean operator or.

All Data Types

Boolean

not

Returns the opposite of a boolean value.

Boolean

empty

Returns true if the value is empty.

All Data Types

Boolean

length

Returns the length of the text or list value.

StringList

Number

substring

Returns the substring of the text from the start index to the end index.

String

contains

Returns true if the search string is present in the value.

String

Boolean

test

Returns true if the value matches the regular expression and false otherwise.

String

Boolean

match

Returns all matches of the regular expression as a list.

String

List

replace

Replaces the first match of the regular expression with the replacement value.

String

replaceAll

Replaces all matches of the regular expression with the replacement value.

String

lower

Converts the text to lowercase.

String

upper

Converts the text to uppercase.

String

repeat

Repeats the text a given number of times.

String

padStart

Returns the text padded with the provided padding string at the start until the target length is reached.

String

padEnd

Returns the text padded with the provided padding string at the end until the target length is reached.

String

link

Creates a hyperlink from the label text and the URL.

String

style

Adds styles and colours to the text.

String

unstyle

Removes formatting styles from the text.

String

format

Formats its argument as a string.

All Data Types

String

add

Returns the sum of two numbers.

Number

subtract

Returns the difference of two numbers.

Number

multiply

Returns the product of two numbers.

Number

mod

Returns the first number modulo the second number.

Number

pow

Returns the result of a base number raised to an exponent power.

Number

divide

Returns the quotient of two numbers.

Number

min

Returns the smallest number of the arguments.

NumberList

Number

max

Returns the largest number of the arguments.

NumberList

Number

sum

Returns the sum of its arguments.

NumberList

Number

median

Returns the middle value of its arguments.

ListNumber

Number

mean

Returns the arithmetic average of its arguments.

ListNumber

Number

abs

Returns the absolute value of the number.

Number

round

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

Number

ceil

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

Number

floor

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

Number

sqrt

Returns the positive square root of the number.

Number

cbrt

Returns the cube root of the number.

Number

exp

Returns e^x

Number

Returns the natural logarithm of the number.

Number

log10

Returns the base 10 logarithm of the number.

Number

log2

Returns the base 2 logarithm of the number.

Number

sign

Returns 1 if the number is positive, -1 if it is negative, and 0 if it is zero.

Number

Returns the ratio of a circle's circumference to its diameter.

Number

Returns the base of the natural logarithm.

Number

toNumber

Parses a number from text.

StringDate

Number

now

Returns the current date and time.

Date

today

Returns the current date without the time.

Date

minute

Returns the minute of the date (0-59).

Date

Number

hour

Returns the hour of the date (0-23).

Date

Number

day

Returns the day of the week of the date, between 1 (Monday) and 7 (Sunday).

Date

Number

date

Returns the day of the month from the date (1-31).

Date

Number

week

Returns the ISO week of the year of the date (1-53).

Date

Number

month

Returns the month of the date (1-12).

Date

Number

year

Returns the year of the date.

Date

Number

dateAdd

Adds time to the date.

Date

dateSubtract

Subtracts time from the date.

Date

dateBetween

Returns the difference between two dates.

Date

Number

dateRange

Returns a date range constructed from the start and end dates.

Date

dateStart

Returns the start of the date range.

Date

dateEnd

Returns the end of the date range.

Date

timestamp

Returns the current Unix timestamp.

Date

Number

fromTimestamp

Returns the date from the given Unix timestamp.

Number

Date

formatDate

Formats the date using a custom format string.

Date

String

parseDate

Returns the date parsed according to the ISO 8601 standard.

String

Date

name

Returns the name of a person.

Person

String

Returns the email address of a person.

Person

String

Returns the value at the specified index in a list.

List

All Data Types

first

Returns the first item in the list.

List

All Data Types

last

Returns the last item in the list.

List

All Data Types

slice

Returns the items of the list from the provided start index to the end index.

List

concat

Returns the concatenation of multiple lists.

List

sort

Returns the list in sorted order.

List

reverse

Returns the reversed list.

List

join

Returns the values of the list with the joiner placed between each of the values.

List

String

split

Returns the list of values created by splitting a text by a separator.

String

List

unique

Returns the list of unique values in the input list.

List

includes

Returns true if the list contains the specified value, and false otherwise.

List

Boolean

find

Returns the first element in the list for which the condition returns true.

List

findIndex

Returns the index of the first item in the list for which the condition evaluates to true.

List

Number

filter

Returns the values in the list for which the condition is true.

List

some

Returns true if any item in the list satisfies the given condition, and false otherwise.

List

Boolean

every

Returns true if every item in the list satisfies the given condition, and false otherwise.

List

Boolean

map

Returns the list populated with the results of calling the expression on every item in the input list.

List

flat

Flattens a list of lists into a single list.

List

Returns the id of the page.

Page

String

equal

Returns true if both values are equal and false otherwise.

All Data Types

Boolean

unequal

Returns false if both values are equal and true otherwise.

All Data Types

Boolean

let

Assigns a value to a variable and evaluates the expression using that variable.

All Data Types

lets

Assigns values to multiple variables and evaluates the expression using those variables.

All Data Types

Name

Description

Accepts

Returns

Alternative

Adds two values together.

StringNumber

add

Subtracts two numbers.

Number

subtract

Multiplies two numbers.

Number

multiply

Returns the first number modulo the second number.

Number

mod

Returns the result of a base number raised to an exponent power.

Number

pow

Divides two numbers.

Number

divide

Checks if two values are equal.

All Data Types

Boolean

equal

Checks if two values are not equal.

All Data Types

Boolean

unequal

Checks if the first value is greater than the second.

StringNumberBooleanDate

Boolean

Checks if the first value is greater than or equal to the second.

StringNumberBooleanDate

Boolean

Checks if the first value is less than the second.

StringNumberBooleanDate

Boolean

Checks if the first value is less than or equal to the second.

StringNumberBooleanDate

Boolean

The boolean operator and.

Boolean

and

The boolean operator or.

Boolean

Returns the opposite of a boolean value.

Boolean

not

? :

The ternary operator.

Boolean

All Data Types

Name

Description

Accepts

Returns

Alternative

true

The boolean value true.

Boolean

false

The boolean value false.

Boolean

Name

Description

Accepts

Returns

Alternative

current

Returns the value of the current item in the list function.

List

All Data Types

index

Returns the index of the current item in the list function, starting from 0.

List

Number