Short Answer

A rollup in Notion can be used to calculate total tasks completed by linking a tasks database with a projects database. Using a relation property, tasks are connected to a project, and then a rollup counts how many tasks are marked as completed.

This helps you quickly see progress without checking each task. It saves time and makes project tracking simple and clear.

Detailed Explanation

Example of rollup for total tasks completed

Setting up databases

To understand this example, imagine you have two databases in Notion. The first database is called “Projects,” and the second database is called “Tasks.”

In the Tasks database, each task has properties like task name and a checkbox property called “Completed.” This checkbox is used to mark whether a task is done or not.

Now, in the Projects database, you want to track how many tasks are completed for each project. For this, you need to connect both databases using a relation property.

You create a relation property in the Tasks database and link it to the Projects database. Then, for each task, you select the project it belongs to. This creates a connection between tasks and projects.

Adding rollup property

After linking the databases, the next step is to add a rollup property in the Projects database. This rollup will help calculate the total completed tasks.

While creating the rollup, you first select the relation property that connects to the Tasks database. Then, you choose the “Completed” checkbox property from the Tasks database.

Finally, you select the calculation method. In this case, you can choose options like “Count checked” or “Percent checked.” If you choose “Count checked,” Notion will count how many tasks are marked as completed.

Now, the rollup will automatically show the total number of completed tasks for each project.

How it works in practice

Once everything is set up, the rollup property updates automatically. Whenever you mark a task as completed in the Tasks database, the rollup in the Projects database will increase the count.

For example, if a project has 10 tasks and 6 of them are marked as completed, the rollup will show 6. This gives you a clear idea of progress without opening the Tasks database.

This automatic update is very helpful because it saves time and reduces manual work. You do not need to count tasks yourself.

Benefits of this example

Using a rollup to calculate total tasks completed has many advantages. It gives a quick overview of progress. You can easily see which projects are moving forward and which ones need attention.

It also improves organization. Instead of checking each task individually, you get all important information in one place.

Another benefit is accuracy. Since the rollup updates automatically, there is less chance of mistakes. You always get correct and updated information.

This method is very useful for project management, team work, and personal productivity.

Expanding the example

You can also expand this setup by adding more rollups. For example, you can calculate total tasks, pending tasks, or completion percentage.

You can even use rollups with other properties like dates to track deadlines or timelines. This makes your database more powerful and useful.

By combining relation and rollup, you can build advanced systems for managing work efficiently.

Conclusion

A rollup property in Notion can easily calculate total tasks completed by linking tasks and projects databases. It automatically counts completed tasks using a checkbox property and shows the result in one place. This makes tracking progress simple, saves time, and improves productivity by giving a clear and accurate overview of work.