How to Use Formulas in Notion
Formulas are a powerful tool to master in Notion, here is a quick overview of how to use them:
- Navigate to a database in which you would like to introduce a property of the type Formula.
- Click on the (+) add icon to add a new property to your database.
- In the property type, search for Formula.
- Click on Formula to select type.
- Customize additional options and close.
- Click on the empty formula field to modify it.
- You now have the option to enter a formula using various tools such as functions. Scroll through the list to view them.
- You can view their correct usage, required fields and description on the right hand side.
- Enter your own customized formula using functions, properties, conditions and outputs. Our example uses a formula to check if the property Progress is not empty then output 1, else 2.
- Click on Done to apply.
- Your property column will be filled based on the output of your Formula.