Logical Functions

Logical functions are the backbone of creating formulas that react and change based on specific conditions. They make your databases truly interactive. Unlike other formulas, logical functions can evaluate conditions and decide which result to return based on the logic you define.

This is useful for managing projects, tracking tasks, or any scenario where the data is not one-dimensional. For example, you might want to highlight tasks that are overdue, or simply display a friendly message when a task is completed. Logical functions make all this possible within Notion.

## Brief Overview

#### if()

The if() function is the cornerstone of conditional logic in Notion. It evaluates a condition and returns one result if the condition is true, and another if it's false. For example, you might use if() to check if a task's due date has passed and return "Overdue" if true, or "On track" if false.

#### ifs()

The ifs() function is like an extended version of if(), allowing you to evaluate multiple conditions in sequence. It's useful when you have several potential conditions and outcomes to consider, and you want to return the first true result.

#### let()

The let() function allows you to define variables within your formulas. This makes your formulas easier to read and maintain. A common use case is calculating complex formulas in steps, storing intermediate results in variables for clarity and reuse.

#### lets()

Similar to let(), the lets() function allows you to define multiple variables at once. It makes managing your formula easier and makes it even cleaner. It's perfect for when you need to use several variables to calculate a final result.

#### and()

The and() function is used to check if all provided conditions are true. It returns true only if every condition is met; otherwise, it returns false.

This function is commonly used when you need to ensure that multiple criteria are satisfied before taking an action. For example, you might use and() to check if a task is both high priority and overdue before sending an urgent reminder to your Slack channel.

#### or()

And the or() function is used to check if at least one of the provided conditions is true. It returns true if any condition is met and false only if all conditions fail.

It is useful for cases where you have multiple acceptable criteria, and you want an action to be taken if any one of them is satisfied. For example, you might use or() to mark a task as needing attention if it is either overdue or marked by a team member.

#### not()

The not() function returns the opposite of a given boolean condition — if the condition is true, not() will return false, and vice versa.

This function is particularly useful for reversing conditions, such as excluding certain items from a view or calculation. For example, you might use not() to filter out completed tasks from a list of active tasks.

#### empty()

Use the empty() function to check if a field is empty. It is useful for conditional logic where you want to perform an action only if a certain piece of data exists.

For example, you might use empty() to conditionally display a message in a task list. If the "Notes" field is empty, you could show "No additional details," to ensure users know there's no extra information without having to check each entry manually.

#### unequal()

These functions are used to compare two values. equal() returns true if the values are identical, while unequal() returns true if they're different. They're frequently used in if() statements to make decisions based on comparisons, such as filtering a view to show only items that have been marked as "Archived."

Previous

Next

Previous

Next