Notion FormulasBasics
Operators and Your First Formula
Common Notion formula operators, recommended syntax, and three minimal formulas you can use right away.
| Operator | Type | Purpose | Example |
|---|---|---|---|
+ | Number / text | Add numbers, or join text | prop("Last Name") + prop("First Name") |
- | Number | Subtract | prop("Budget") - prop("Expense") |
* | Number | Multiply | prop("Unit Price") * prop("Quantity") |
/ | Number | Divide | prop("Total Score") / 3 |
% | Number | Remainder | prop("Number") % 2 |
^ | Number | Exponent | 2 ^ 3 |
== | Comparison | Equal to | prop("Status") == "Completed" |
!= | Comparison | Not equal to | prop("Status") != "Completed" |
> | Comparison | Greater than | prop("Score") > 90 |
< | Comparison | Less than | prop("Stock") < 10 |
>= | Comparison | Greater than or equal to | prop("Score") >= 60 |
<= | Comparison | Less than or equal to | prop("Age") <= 18 |
and / && | Logic | Both conditions are true | prop("Done") and prop("Archived") |
or / ` | ` | Logic | |
not / ! | Logic | Negate a condition | not prop("Done") |
condition ? trueValue : falseValue | Condition | Ternary expression | prop("Score") >= 60 ? "Pass" : "Fail" |
Recommended syntax
For complex conditions, the English word form is easier to read:
Do not use a single | for logical OR. Use or or ||.
To use these formulas directly in task reminders, project progress, note heatmaps, and reports, continue with FLO.W Notion Template.
Last updated on