Reference Properties in Formulas
Learn how to reference other database properties in Notion formulas in order to access their data.
Within a Notion formula, you can use the
prop()function to reference and "pull in" the data from any other property in the same database.
prop(), encapsulate the property name in quotes – e.g.
All database property types in Notion output a specific data type.
Refer to the following table to see the data type of each property:
This database contains an example of every property type in Notion referenced within a formula:
- The data type of the property the Rollup is referencing
- The Rollup's Calculate setting
When a Rollup's Calculate setting is set to Show Original, it will always output a string value.
This is due to the fact that a Rollup can show the property values for multiple database rows – e.g. a Rollup targeting a number property may show a value of
4, 6, 2if the current row is related to three other rows.
When Show Original is set:
When a Calculate setting other than Show Original is chosen, the Rollup will output a different data type:
- If the Rollup is targeting a number or Boolean-type property, all Calculate settings (other than Show Original) will output a number.
Note that a Rollup cannot access the End Date of a date property, even if one is set. If you need to pull the end date of a date property through a Rollup, you'll need to first create a formula property that uses the end function to output that end date, then configure your Rollup to target that formula property.
Duplicate this example database into your own workspace and try reconfiguring the Rollup property.
Note that changing the settings may require you to click into the Formula property and hit Enter to get it to output data again - even if the Rollup configuration change didn't cause a Type Mismatch error in your formula.
My name is Thomas Frank, and I'm a Notion-certified writer, YouTuber, and template creator. I've been using Notion since 2018 to organize my personal life and to run my business and YouTube channel. In addition to this formula reference, I've created a free Notion course for beginners and several productivity-focused Notion templates. If you'd like to connect, follow me on Twitter.