Here you will find the complete list of the most frequently used notion formulas for efficient calculations & advanced functionality.
<aside> 💡
NOTE: Use the table of contents pop-out bar in the far-right side of your screen for faster navigation.
</aside>
| Name | Result | Formula |
|---|---|---|
| Add | Returns the sum of a and b. | add(a, b) |
| Subtract | Returns the result of a minus b. | subtract(a, b) |
| Multiply | Returns the product of a and b. | multiply(a, b) |
| Divide | Returns the result of a divided by b. | divide(a, b) |
| Modulo | Returns the remainder of a divided by b. | mod(a, b) |
| Power | Returns the base raised to the power of the exponent. | pow(base, exponent) |
| Name | Result | Formula |
|---|---|---|
| Current Time | Returns the current date and time. | now() |
| Current Date | Returns the current date. | today() |
| Add to Date | Adds a specified amount of time to a date. | dateAdd(date, number, unit) |
| Subtract from Date | Subtracts a specified amount of time from a date. | dateSubtract(date, number, unit) |
| Date Difference | Returns the difference between two dates in the specified unit. | dateBetween(date1, date2, unit) |
| Format Date | Formats a date according to the specified format string. | formatDate(date, format_string) |
| Date Start | Extracts the start date from a date range. | dateStart(date_range) |
| Date End | Extracts the end date from a date range. | dateEnd(date_range) |
| Minute Difference | Calculates the minute difference between two dates. | dateBetween(date1, date2, "minutes") |
| Week Number | Returns the week number of the year for a given date. | formatDate(date, "W") |
| Name | Result | Formula |
|---|---|---|
| Concatenate | Concatenates multiple strings into one. | concat(string1, string2, ...) |
| Format Number | Converts a number into a string. | format(number) |
| String Length | Returns the number of characters in a string. | length(string) |
| Substring | Returns a substring starting at the specified position with the given length. | substring(string, start, length) |
| Contains | Returns true if the string contains the specified substring. | contains(string, substring) |
| Replace | Replaces the first occurrence of old with new in the string. | replace(string, old, new) |
| Replace All | Replaces all occurrences of old with new in the string. | replaceAll(string, old, new) |
| Lowercase | Converts all characters in the string to lowercase. | lower(string) |
| Uppercase | Converts all characters in the string to uppercase. | upper(string) |
| Trim | Removes leading and trailing spaces from the string. | trim(string) |
| Starts With | Returns true if a string starts with a specific substring. | startsWith(string, substring) |
| Ends With | Returns true if a string ends with a specific substring. | endsWith(string, substring) |
| Name | Result | Formula |
|---|---|---|
| And | Returns true if all arguments are true. | and(a, b, ...) |
| Or | Returns true if at least one argument is true. | or(a, b, ...) |
| Not | Returns the opposite boolean value of a. | not(a) |