Once you start using Notion's relational property, you'll quickly realize that you might want to do more with the data that's been synced and shared between your databases. For example, you might want to not just see a list of tasks that belong to a specific project, but also count them, or see how many have been completed, checked off, or belong to a certain tag.

That's where Notion's rollup property comes in. In this tutorial, we'll show you how to use it to get more out of your relational data.

What is Notion's Rollup Property?

The rollup property is a type of database property in Notion that allows you to reference and manipulate data from a related database. For example, if you have a database of tasks and a database of projects, and you have linked the two databases together using a relational property, you can use a rollup property to reference the tasks that belong to a specific project and perform calculations on them. This could include counting the number of tasks, summing their values, or finding the average of a property.

How to create a rollup property in Notion

To create a rollup property in Notion, follow these steps:

1. Click on the plus icon to add a new property to the database you want to reference.
2. Scroll down to the "rollup" option in the property type dropdown menu and select it.
3. Choose the relation you want to use for the rollup.
4. Select the property you want to reference in the rollup. For example, you might choose the "done" property to count the number of tasks that have been completed.
5. Use the "Calculation" field to perform calculations on the data in the rollup property. For example, you can calculate the percentage of tasks that have been completed to be displayed as a progress bar.
6. Save the property to apply the changes. You can now use the rollup property to get more out of your relational data, including calculating percentages and other useful metrics.

Examples of how to use a rollup property

After you have created your rollup property, you can use it in your database just like any other property. You can display it on a database view or use it in filters and formulas to manipulate and organize your data. Here are a few examples of how you can use a rollup property in your Notion databases:

1. To track the progress of a project: By using the rollup property to count the number of tasks that have been completed, you can quickly see how far along a project is and whether it's on track to meet its deadlines.
2. To manage your team's workload: By using the rollup property to count the number of tasks assigned to each team member, you can ensure that your team members are not overwhelmed with too many tasks and that the workload is distributed evenly.
3. To monitor your sales pipeline: By using the rollup property to count the number of leads at each stage of your sales process, you can easily see where your pipeline is strong and where it might be weak.
4. To monitor your inventory levels: By using the rollup property to count the number of items in your inventory, you can easily see when it's time to restock and avoid running out of products.
5. To track customer feedback: By using the rollup property to count the number of positive and negative customer reviews, you can get a sense of how your customers feel about your products or services and make improvements if necessary.

Using Notion's rollup property is an incredibly useful way to summarize information across related databases. It's a way to really start leveraging Notion's most powerful features, and can really level up how you run your business in Notion.

If you found this video and tutorial useful, consider taking our complete Notion For Business Systems course; where you'll learn how to setup and run your entire business in Notion in 21 days.