Summing Sprint Estimates in Notion: Creating a Rollup Property for Total Estimates

In this article, we’ll show you how to create a Rollup property in Notion to keep track of the total estimates for each sprint in your Notion workspace.

This feature can be a helpful way to streamline project management and help you stay organized.

Follow the simple steps outlined in this article to easily implement this feature in your workspace.

Our problem -> The Estimates is a select type property and you cannot make use the sum function for it.

Proposed solution

1. In the Task view, create a new Formula property, give it a name and paste this formula: toNumber(prop("Estimates"))
   This will convert the Estimates field to a number so it can be used later.

2. In the Sprint view, create a new Rollup property and make it to be in relation to Tasks and use the previously created Estimation value and do a sum for it. Now each sprint will have a Total estimation property.

3. Make the Estimation value to also be used when viewing all the sprints in the Sprint Planning section. Click on that tasks counter and choose our new Estimation value property.

And that’s it! By following these steps, you can easily keep track of the total estimates for each sprint in your Notion workspace. This can be incredibly helpful for project management and keeping your team on track.