what is prop in notion formula

What's "Prop" in Notion Formulas: A Quick Guide

By Laura Martin
AD

Have you ever found yourself in a situation where you needed to calculate something in a complex document, only to realize you don't have the right tool for the job? This is where the power of prop in Notion comes into play. Notion, a versatile productivity platform, offers a robust feature set that includes databases and formulas, allowing you to perform calculations right within your notes, projects, or dashboards.

Among the various functions that Notion offers, 'prop' is a potent formula language that enables you to extract, manipulate, and calculate data. It's a lifesaver when you need to transform raw data into meaningful and actionable insights.

Understanding Props in Notion

Props, short for 'properties,' are Notion's way of allowing you to add, manipulate, and even create data within your workspace. They serve as the building blocks for your pages, databases, and templates.

AD
Free Notion Progress Bar Formulas
Free Notion Progress Bar Formulas
Notion Formulas, Rollups, and Databases Full Guide for Beginners
Notion Formulas, Rollups, and Databases Full Guide for Beginners
NOTION FORMULAS EVERY NOTION USER SHOULD KNOW
NOTION FORMULAS EVERY NOTION USER SHOULD KNOW

In Notion's formula language, you use the 'prop' keyword to refer to these properties. It's how you tell Notion that you want to pull data from a property or use it in some way in your formula.

Accessing Properties Using Props

To extract data from a property, you simply prefix the property name with 'prop.' For example, if you have a 'Date' property named "Event Start," you would refer to it in a formula as 'prop.Date.Event Start'.

an email form with the words formulas and numbers on it, including two columns
an email form with the words formulas and numbers on it, including two columns
Display your relative dates the expert way.
Display your relative dates the expert way.
How to Build a Notion Progress Formula for Project Tracking
How to Build a Notion Progress Formula for Project Tracking

Consider a page where you're tracking a project's progress. You could use a prop in Notion to display the project's start date or end date. The formula would look something like this: 'prop.Date.Project Start' or 'prop.Date.Project End'.

Calculating with Props

Props aren't just limited to extracting data. You can also use them to perform calculations. For instance, you can use props to determine how many days left until a project's deadline. Let's say your "Project End" date is a 'Date' property and today's date is stored in a 'prop.Now()' function. You could use the following formula to calculate the remaining days:

AD

'prop.Date.Project End' - 'prop.Now()', which would return the difference in days between the project's end date and today.

Master Notion Formulas: Boost Your Productivity Today 305
Master Notion Formulas: Boost Your Productivity Today 305
NOTION FORMULAS TEXT COLOR CHEAT SHEET FOR BEGINNERS
NOTION FORMULAS TEXT COLOR CHEAT SHEET FOR BEGINNERS
Upgrade your duration display in Notion ⏱️👇
Upgrade your duration display in Notion ⏱️👇
2025 Notion Formula Templates for Beginners 724
2025 Notion Formula Templates for Beginners 724
Notion if statements — 5 patterns that cover almost every use case (with examples)
Notion if statements — 5 patterns that cover almost every use case (with examples)
a screenshot of the basic formula structure for an article on how to use it
a screenshot of the basic formula structure for an article on how to use it

Beyond Basic Calculations

The power of props truly shines when you combine them with other Notion formulas and functions. You can use them to filter, sort, and even group your data in unique ways.

Let's say you have a large team working on various projects. You could use props in combination with 'groupBy' to sort tasks by assignee or project, giving team members a clear overview of their workloads.

AD

Formulas Within Props

You can nest formulas within props to create more complex calculations. For example, if you have a project with multiple milestones, each with its own duration, you could use a combination of 'sum' and 'prop' to calculate the total project duration:

🎁 free Notion tutorial
🎁 free Notion tutorial

'sum(prop.Number.Milestone Duration)' would give you the total number of days for all milestones, providing a quick way to check if your project is on schedule.

Using Props in If Statements

Props can also be used in 'if' statements to create conditional results. For example, you could use an 'if' statement to display a warning message only when a project's end date is less than five days away:

AD

'if(prop.Date.Project End - prop.Now() < 5, "Project deadline is approaching!", "")'. This would display the warning message if the deadline was close and leave the cell blank otherwise.

In Notion, the possibilities are endless. Whether you're calculating a project's total duration, determining task assignments, or creating custom reports, props in Notion offer you a powerful way to transform data into meaningful insights. So, next time you find yourself in need of a calculation, remember to look into Notion's prop possibilities. Your documents, databases, and workflows will thank you!

AD