Boolean (Checkbox)

Learn about the Boolean (Checkbox) data type in Notion formulas.

Boolean values represent truth states: either true or false.

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:

  • false
  • 0
  • -0
  • "" (an empty string)

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:

  • true
  • "0" – a string containing 0
  • "false" – a string containing “false”
  • "anything" – a string containing any text
  • now() – a date (the now function outputs the current date and time as a date object)

You can see proofs of these statements in this example database:

Notion – The all-in-one workspace for your notes, tasks, wikis, and databases.
A new tool that blends your everyday work apps into one. It’s the all-in-one workspace for you and your team
thomasfrank.notion.site

Notion comes with several Boolean operators.

These can be used to perform comparisons between two values (which must share the same data type), outputting a true or false value.

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.

Good to know: Notion is picky about how you must write logical operators. Only the listed symbols will work, and they are case-sensitive.
E.g. You must use and for the and operator – And, AND, and && will not work in Notion.

OperatorSymbolFunction VersionExample
andandand()2 > 3 and 4 < 8
ororor()2 > 1 or 6 > 5
notnotnot()not empty("Hello")

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

Notion provides six comparison operators:

OperatorSymbolFunction VersionExample
equal==equal()2 == 2
unequal!=unequal()4 != 2
larger>larger()5 > 3
largerEq>=largerEq()4 >= 4
smaller<smaller()6 < 9
smallerEq<=smallerEq()9 <= 9
About the Author

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.

🤔 Have an UB Question?

Fill out the form below and I’ll answer as soon as I can! ~Thomas

🤔 Have a Question?

Fill out the form below and I’ll answer as soon as I can! ~Thomas