not
Learn how to use the Boolean "not" operator in Notion formulas.
The not operator inverts the truth value of a Boolean/Checkbox value in a Notion formula. Another way of thinking about it is that it returns true only if its operand is false. It accepts Boolean operands.
1
not Boolean
2
not(Boolean)
It can be used in several ways, including:
  • Changing true to false, or vice-versa
  • Checking whether a property is not empty
  • Inverting the truth value of an if statement
Good to know: Notion is picky, so !, NOT, and Not won't work here. Only the case-sensitive not will be accepted.
You can also use the function version, not().

1
not true // Output: false
2
​
3
not(true) // Output: false
4
​
5
not empty("Hello") // Output: true
6
​
7
not if(50>40,true,false) // Output: false

This example database shows a list of applications to join a pirate crew. The captain only wants to hire pirates that have powers, and he won’t accept anyone with snot-based powers. That’d be gross.
The Interview checkbox returns true only if both of those conditions are met. The Interviews view filters by this checkbox, showing the captain only the candidates that meet his conditions.

not
College Info Geek on Notion

1
// Compressed
2
if(not empty(prop("Power")) and not test(prop("Power"), "[Ss]not"), true, false)
3
​
4
// Expanded
5
if(
6
not empty(
7
prop("Power")
8
) and not test(
9
prop("Power"), "[Ss]not"
10
),
11
true,
12
false
13
)
This formula uses a couple other functions:
  • ​empty - tests to see if the Power property is empty
  • ​test - tests to see if the first argument (the Power property’s string value) contains the second argument, β€œSnot”.
    • By writing β€œ[Ss]” the test() function will catch both cases; normally, it is case-sensitive.

​
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 21d ago
Copy link
On this page
Example Formula
Example Database
View and Duplicate Database
"Interview" Property Formula