Formula Components

Formulas and Databases

Reference

Formula Examples

Operators

A reference list of all operators available for use in Notion formulas.

Operators are symbols that tell Notion's formula engine to perform specific operations.

Here's a very simple example:

1

2 + 2

This statement uses the add (

`+`

) operator to perform addition on two numbers. This formula will return a result of `4`

.The numbers on each side of the **operands. **Operands are the discrete data objects that are either evaluated or manipulated by the operator.

`+`

operator are called In Notion formulas, operands have one of four data types - string, number, Boolean (checkbox), and date.

Operands can be hard-coded:

1

"Monkey D. Luffy will be " + "King of the Pirates!"

They can also pass data from another database property:

1

prop("First Name") + prop("Last Name")

You can also mix and match:

1

prop("First Name") + " " + prop("Last Name") + " will be King of the Pirates!"

Notion's formula editor provides three types of operators:

- 1.Mathematical operators
- 2.Logical operators
- 3.Comparison operators
- 4.Special Operators

Mathematical operators allow you to do math on numbers.

Here are all the mathematical operators Notion provides. Note that Notion also provides a function version of each one, which I've listed in the reference table.

Logical operators return a Boolean value, and often allow you to combine and evaluate multiple expressions.

Notion provides three logical operators.

Comparison operators allow you to compare operands that share a data type.

Notion provides six comparison operators:

E.g.

`1 < 2 < 3`

will not work. Instead, use `1 < 2 and 2 < 3`

.Notion also provides two special operators that don't fit neatly into the categories above.

The if operator - also known as the ternary operator - lets you create if-then statements and branching logic in Notion formulas.

Notion formulas can contain many operators, which can let you solve complex problems.

For example:

1

// Output: true

2

-((+"5")^2) < 20 - 10 ? true : false

When multiple operators are present in a Notion formula, their order of execution is determined by Notion's operator precedence rules:

β My name is Thomas Frank, and I'm a Notion-certified writer, YouTuber, and template creator. I've been using Notion since 2018 to organize my personal life and to run my business and YouTube channel. In addition to this formula reference, I've created a free Notion course for beginners and several productivity-focused Notion templates. If you'd like to connect, follow me on Twitter.

Last modified 7h ago

Copy link

On this page

Mathematical Operators

Logical Operators

Comparison Operators

Special Operators

Operator Precedence