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.


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.