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

  1. Create a Projects database and a Tasks database. Add a numeric Estimate in hours to the Tasks database.
  2. Add a relation from tasks to projects. Link each sample task to its owning project and display the reverse relation on the project.
  3. Add a project rollup using its related tasks, the Estimate property and the Sum calculation.
  4. 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.

View Notion

References