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