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

round · Notion Formulas · Ben Smith

&& / and · Notion Formulas · Ben Smith

dateSubtract · Notion Formulas · Ben Smith

timestamp · Notion Formulas · Ben Smith

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

floor · Notion Formulas · Ben Smith

Ben Smith · Digital Designer & Notion Expert

toNumber · Notion Formulas · Ben Smith

== · Notion Formulas · Ben Smith

Content pulled from the main formula panel, with working examples.

Notion Formulas · Ben Smith

Checks if the first value is less than the second.

< · Notion Formulas · Ben Smith

Returns the value that corresponds to the first true condition. 

ifs · Notion Formulas · Ben Smith

* · Notion Formulas · Ben Smith

empty · Notion Formulas · Ben Smith

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

current · Notion Formulas · Ben Smith

minute · Notion Formulas · Ben Smith

style · Notion Formulas · Ben Smith

|| / or · Notion Formulas · Ben Smith

Returns the value at the specified index in a list.

at · Notion Formulas · Ben Smith

sum · Notion Formulas · Ben Smith

hour · Notion Formulas · Ben Smith

A selection of free and paid templates for all manner of things.

Notion Templates · Ben Smith

- · Notion Formulas · Ben Smith

dateStart · Notion Formulas · Ben Smith

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

replace · Notion Formulas · Ben Smith

true · Notion Formulas · Ben Smith

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

join · Notion Formulas · Ben Smith

false · Notion Formulas · Ben Smith

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

substring · Notion Formulas · Ben Smith

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

<= · Notion Formulas · Ben Smith

!= · Notion Formulas · Ben Smith

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

day · Notion Formulas · Ben Smith

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

lets · Notion Formulas · Ben Smith

Returns the concatenation of multiple lists.

concat · Notion Formulas · Ben Smith

and · Notion Formulas · Ben Smith

Returns false if both values are equal and true otherwise.

unequal · Notion Formulas · Ben Smith

not · Notion Formulas · Ben Smith

Returns true if both values are equal and false otherwise.

equal · Notion Formulas · Ben Smith

multiply · Notion Formulas · Ben Smith

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

replaceAll · Notion Formulas · Ben Smith

Examples for questions found on the internet.

Notion Examples · Ben Smith

Returns the first number modulo the second number.

% · Notion Formulas · Ben Smith

subtract · Notion Formulas · Ben Smith

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

contains · Notion Formulas · Ben Smith

now · Notion Formulas · Ben Smith

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

ceil · Notion Formulas · Ben Smith

mod · Notion Formulas · Ben Smith

or · Notion Formulas · Ben Smith

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

date · Notion Formulas · Ben Smith

first · Notion Formulas · Ben Smith

format · Notion Formulas · Ben Smith

Returns the difference between two dates.

dateBetween · Notion Formulas · Ben Smith

Formats the date using a custom format string.

formatDate · Notion Formulas · Ben Smith

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

>= · Notion Formulas · Ben Smith

month · Notion Formulas · Ben Smith

? :  · Notion Formulas · Ben Smith

dateAdd · Notion Formulas · Ben Smith

! / not · Notion Formulas · Ben Smith

reverse · Notion Formulas · Ben Smith

+ · Notion Formulas · Ben Smith

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

let · Notion Formulas · Ben Smith

Returns the length of the text or list value.

length · Notion Formulas · Ben Smith

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

map · Notion Formulas · Ben Smith

Returns the date from the given Unix timestamp.

fromTimestamp · Notion Formulas · Ben Smith

last · Notion Formulas · Ben Smith

Returns the largest number of the arguments.

max · Notion Formulas · Ben Smith

Returns the absolute value of the number.

abs · Notion Formulas · Ben Smith

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

split · Notion Formulas · Ben Smith

year · Notion Formulas · Ben Smith

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

if · Notion Formulas · Ben Smith

sort · Notion Formulas · Ben Smith

Returns the date parsed according to the ISO 8601 standard.

parseDate · Notion Formulas · Ben Smith

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

includes · Notion Formulas · Ben Smith

add · Notion Formulas · Ben Smith

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

slice · Notion Formulas · Ben Smith

dateEnd · Notion Formulas · Ben Smith

A few tips and tricks, plus longer guides and setups.

Notion Guides · Ben Smith

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

test · Notion Formulas · Ben Smith

/ · Notion Formulas · Ben Smith

divide · Notion Formulas · Ben Smith

Checks if the first value is greater than the second.

> · Notion Formulas · Ben Smith

prop("Checked") == true ? "Complete" : "Incomplete"