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.

When using prop(), encapsulate the property name in quotes – e.g. prop("Name").

prop("Name")

Notion formulas can work with seven different data-typesstring (text content), number, Boolean (checkbox), date, list, person, and page.

All database property types in Notion output a specific data type.

Good to know: Any time this reference states that a function “accepts only numbers as arguments” (or any of the other data types), understand that the function can also accept prop() as an argument, so long as the referenced property is outputting that data type.

Example: Assume a property called Num is a Number-type property. The max function accepts numbers, so max(5, 10, prop("Num")) would be valid.

Refer to the following table to see the data type of each property:

PropertyData TypeNotes
TitleStringThis is the default “Name” property that all database are required to have.
TextString
NumberNumber
SelectString
Multi-SelectListReturns a comma-separated string of all values present in the Multi-Select property.
StatusStringReturns a string even if the Status property is displayed as a Checkbox.
DateDateUse the dateStart and dateEnd functions to access dates in a date range.
PersonListReturns a list of Person data types.
Files & MediaListReturns a list of string URLs for the assets.
CheckboxBoolean
URLString
EmailString
PhoneString
FormulaStringNumberBooleanDateListPersonPageCan return any of the data types.
RelationListReturns a list of Page data types.
RollupStringNumberDateSee Notes on Rollups below.
Create timeDate
Created byPersonReturns a single Person data type.
Last edited timeDate
Last edited byPersonReturns a single Person data type.

This database contains an example of every property type in Notion referenced within a formula:

Notion – The all-in-one workspace for your notes, tasks, wikis, and databases.
A new tool that blends your everyday work apps into one. It’s the all-in-one workspace for you and your team
thomasfrank.notion.site

Learn more about Rollups in my complete guide to Notion databases.

The data type of a Rollup referenced in a formula depends on both:

  • 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, 2 if the current row is related to three other rows.

When Show Original is set:

  • A Rollup targeting a number-type property will output a numeric character (e.g. 4), but it’s still a string. (Use toNumber in your formulas to convert it)
  • A Rollup targeting a Boolean-type property will output a string value of Yes or No (use if to perform Boolean comparisons on these)
  • A Rollup targeting a Date-type property will output a string value representing the date value(s) being rolled up. Even if only one date is shown, the value is still a string (not a date).

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.
  • If the Rollup is targeting a date-type property, the Earliest date, Latest date, and Date range settings will output a date. Date range outputs a date object with both a start and end date, allowing you to access either using the start and end functions.

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.

Notion – The all-in-one workspace for your notes, tasks, wikis, and databases.
A new tool that blends your everyday work apps into one. It’s the all-in-one workspace for you and your team
thomasfrank.notion.site
About the Author

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.

🤔 Have an UB Question?

Fill out the form below and I’ll answer as soon as I can! ~Thomas

🤔 Have a Question?

Fill out the form below and I’ll answer as soon as I can! ~Thomas