The Notion Formula Cheatsheet: 44 Common Formulas with Examples

You can find the common 44 Notion formulas below in table format.

If you prefer to have them as a Notion page, here is the link to the Notion page I prepared for you: Notion Formulas Notion Page

Text Formulas for Notion

Formula	Explanation	Example Formula	Example Explanation
concat()	Combines multiple strings into one.	concat("Hello, ", "world!")	This formula combines “Hello, ” and “world!” into “Hello, world!”.
length()	Returns the length of a string.	length("Notion")	This formula returns the length of the string “Notion”, which is 6.
slice()	Extracts a substring from a string based on start and end index.	slice("Notion", 1, 4)	This formula extracts the substring “oti” from “Notion”.
contains()	Checks if a string contains a specified substring.	contains("Notion", "no")	This formula checks if “Notion” contains “no”, which is true.
startsWith()	Checks if a string starts with a specific substring.	startsWith("Notion", "No")	This formula checks if “Notion” starts with “No”, which is true.
endsWith()	Checks if a string ends with a specific substring.	endsWith("Notion", "on")	This formula checks if “Notion” ends with “on”, which is true.
format()	Formats a value as a string according to a specified pattern.	format(123, "Your number is: #")	This formula formats the number 123 into the string “Your number is: 123”.
join()	Merges elements of an array into a string separated by the specified separator.	join(["Hello", "world"], " ")	This formula joins “Hello” and “world” with a space, resulting in “Hello

Date & Time Formulas for Notion

Formula	Explanation	Example Formula	Example Explanation
now()	Returns the current date and time.	now()	This formula simply returns the current date and time.
dateAdd()	Adds a specified time period to a date.	dateAdd(now(), 7, "days")	Adds 7 days to the current date, returning a date one week later.
dateSubtract()	Subtracts a specified time period from a date.	dateSubtract(now(), 3, "days")	Subtracts 3 days from the current date.
dateBetween()	Calculates the difference between two dates.	dateBetween(now(), prop("Due Date"), "days")	Calculates the number of days between today and the “Due Date” property of a page.
formatDate()	Formats a date according to a specified pattern.	formatDate(now(), "YYYY-MM-DD")	Formats the current date as “Year-Month-Day”.
timestamp()	Converts a date into a Unix timestamp.	timestamp(now())	Converts the current date and time into a Unix timestamp.
fromTimestamp()	Converts a Unix timestamp into a Notion date.	fromTimestamp(1609459200)	Converts the Unix timestamp 1609459200 into a readable Notion date.
startOfMonth()	Finds the first day of the month for a given date.	startOfMonth(now())	Returns the first day of the current month.
endOfMonth()	Finds the last day of the month for a given date.	endOfMonth(now())	Returns the last day of the current month.

Numerical & Logical Formulas for Notion

Formula	Explanation	Example Formula	Example Explanation
+ (Addition)	Adds two numbers or concatenates strings.	3 + 5	Adds 3 and 5 to get 8.
- (Subtraction)	Subtracts one number from another.	10 - 4	Subtracts 4 from 10 to get 6.
* (Multiplication)	Multiplies two numbers together.	6 * 7	Multiplies 6 and 7 to get 42.
/ (Division)	Divides one number by another.	20 / 4	Divides 20 by 4 to get 5.
% (Modulo)	Finds the remainder after division of one number by another.	10 % 3	Finds the remainder of 10 divided by 3, which is 1.
^ (Exponentiation)	Raises a number to the power of another number.	2 ^ 3	Raises 2 to the power of 3 to get 8.
== (Equal)	Checks if two values are equal, returning true or false.	3 == 3	Checks if 3 equals 3, which is true.
!= (Not Equal)	Checks if two values are not equal, returning true or false.	3 != 4	Checks if 3 does not equal 4, which is true.
> (Greater Than)	Checks if one value is greater than another.	5 > 3	Checks if 5 is greater than 3, which is true.
< (Less Than)	Checks if one value is less than another.	2 < 4	Checks if 2 is less than 4, which is true.
if()	Executes conditional logic based on a specified condition.	if(3 > 2, "Yes", "No")	Checks if 3 is greater than 2 and returns “Yes”, otherwise “No”.
round()	Rounds a number to the nearest integer or specified number of decimal places.	round(2.67)	Rounds 2.67 to the nearest whole number, which is 3.
abs()	Returns the absolute value of a number.	abs(-5)	Returns the absolute value of -5, which is 5.
ceil()	Rounds a number up to the nearest integer.	ceil(2.3)	Rounds 2.3 up to the nearest whole number, which is 3.
floor()	Rounds a number down to the nearest integer.	floor(2.7)	Rounds 2.7 down to the nearest whole number, which is 2.
exp()	Calculates the exponent of e to the power of the given number.	exp(1)	Calculates the exponent of e to the power of 1, which is e (approximately 2.71828).
log()	Calculates the natural logarithm of a number.	log(e)	Calculates the natural logarithm of e, which is 1.
max()	Returns the maximum value among the provided numbers.	max(3, 7, 2)	Returns the maximum value, which is 7.
min()	Returns the minimum value among the provided numbers.	min(3, 7, 2)	Returns the minimum value, which is 2.
rand()	Generates a random number between 0 and 1.	rand()	Generates a random number between 0 and 1.
sqrt()	Calculates the square root of a number.	sqrt(16)	Calculates the square root of 16, which is 4.

Advanced Notion Formulas

Formula	Explanation	Example Formula	Example Explanation
let	Defines a local variable within a formula for reuse.	let(SalesTax, prop("Subtotal")*0.099, prop("Subtotal") + SalesTax)	Defines SalesTax as Subtotal * 0.099, then adds SalesTax to Subtotal.
lets	Similar to let but allows for multiple variable assignments within one formula.	lets(a, "Hello", b, "world", a + " " + b)	Assigns “Hello” to a and “world” to b, then concatenates them with a space.
map()	Transforms each item in a list using a provided function.	prop("Tasks").map(current => current.prop("Status"))	Applies a function to each “Status” property in the “Tasks” list, transforming the list.
filter()	Filters items in a list based on a condition.	prop("Tasks").filter(current => current == "Complete")	Filters the “Tasks” list to include only those marked as “Complete”.
length()	Determines the number of items in a list or the length of a string.	length(prop("Tasks"))	Returns the number of items in the “Tasks” list.
ifs()	Evaluates multiple conditions and returns a value for the first true condition.	ifs(prop("Score") > 90, "A", prop("Score") > 80, "B", "C")	Returns “A” if “Score” is above 90, “B” if above 80, otherwise “C”.