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”. |