Learn about the Boolean (Checkbox) data type in Notion formulas.
Notion represents Boolean values as checkboxes:
- True is represented by a checked box
- False is represented by an unchecked box
These resources aren’t necessary for understanding how to work with Booleans in Notion, but you may find them interesting if you want to dive deeper into how Booleans are used in programming and computer science.
True or false Boolean values are usually determined by the outcome of a statement containing a Boolean operator. For example:
10 > 5 // Output: True
"Monkey" == "Banana" // Output: False
However, there are also some values in Notion formulas that are inherently truthy or falsy.
The following values in a Notion formula are always falsy:
You can test this for yourself by creating a Notion formula containing this statement, which outputs false:
0 ? true : false // Output: False
By contrast, the following will output true:
1 ? true : false // Output: True
All values not listed above are inherently truthy, including:
You can see proofs of these statements in this example database:
They can be separated into two categories: logical operators and comparison operators.
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:
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.