Learn how to use the Boolean "not" operator in Notion formulas.
It can be used in several ways, including:
You can also use the function version,
not true // Output: false
not(true) // Output: false
not empty("Hello") // Output: true
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.
if(not empty(prop("Power")) and not test(prop("Power"), "[Ss]not"), true, false)
) and not test(
This formula uses a couple other functions:
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.