How to Use Formulas in Notion

Quick summary

Notion's Formula property lets you run dynamic calculations and conditional logic directly inside a database, turning static data into smart, auto-updating outputs. You can build formulas using built-in functions, reference other properties, and apply conditions to automate how each row is evaluated.

Steps

1. Navigate to a database in which you would like to introduce a property of the type Formula.
2. Click the (+) add icon to add a new property to your database.
3. In the property type search field, search for Formula.
4. Click on Formula to select it as the property type.
5. Customize additional options and close the property panel.
6. Click on the empty formula field to open and modify it.
7. Browse the available functions by scrolling through the list to view all options.
8. Review the correct usage, required fields, and description shown on the right-hand side.
9. Enter your own customized formula using functions, properties, conditions, and outputs — for example, using an if condition to check whether a property like Progress is not empty.
10. Click Done to apply your formula.
11. Confirm that your property column is now populated based on the output of your Formula.