Roll Up Task Estimates to Projects in a Notion Database
Keep task estimates on the task rows and use a rollup to display each project's total. Verify how shared tasks are accounted for before publishing the totals.
Worked example
Synthetic project estimates
Project = Catalog refresh Task 1 = Check filters, 1.5 hours Task 2 = Rewrite size guide, 2 hours Task 3 = Review screenshots, 0.5 hours Expected rollup = 4 hours After moving Task 3 to Launch assets, Catalog refresh should show 3.5 hours.
Steps
- Create a Projects database and a Tasks database. Add a numeric Estimate in hours to the Tasks database.
- Add a relation from tasks to projects. Link each sample task to its owning project and display the reverse relation on the project.
- Add a project rollup using its related tasks, the Estimate property and the Sum calculation.
- Compare the project total to the task rows, then move one task to a different project to check that both totals update.
What to check
- Use one unit in the source column. Mixing minutes and hours gives a plausible but false total.
- For shared work, decide whether to assign one owning project or split the effort into separate tasks before rolling up estimates.