How-To2026-08-289 min read

How to Create a Sprint Capacity Planner in Notion

Notion's database rollup and formula system makes it possible to build a sprint capacity planner that is both structured data (filterable, sortable) and readable narrative — the advantage over a Google Sheet is that the capacity planner can live alongside the sprint backlog and team documentation in one Notion workspace.

This guide covers how to build a sprint capacity planner in Notion using linked databases for team roster and sprint backlog, formula properties for capacity calculations, and templates that make each sprint planning session faster than the last.

Step-by-step guide

01

Create the Team Members database

Create a Notion database called "Team Members" with properties: Name (title), Role (select: Frontend, Backend, Full Stack, QA), Sprint Velocity (number — average story points per sprint), Daily Coding Hours (number — default 5.5 to account for meetings), and Current Allocation % (number — percentage dedicated to this team). This database is maintained once and referenced by every sprint plan.

02

Create the Sprint Capacity database

Create a database called "Sprint Capacity Plans" with properties: Sprint Name (title), Start Date (date), End Date (date), and Status (select: Planning, Active, Complete). Each sprint gets one entry. Create a relational property to Team Members so each sprint plan lists its team members. Add a formula to calculate Sprint Length in working days from Start and End dates.

03

Build the sprint entry template

Create a template in the Sprint Capacity Plans database. In the template body, add a table with columns: Engineer (from Team Members relation), PTO Days, Holiday Days, Available Days (formula: Sprint Length - PTO - Holidays), Adjusted Velocity (formula: Available Days × Daily Coding Hours / Full Sprint Hours × Sprint Velocity), and Committed Points (manual entry). Add a Recommended Commitment row at the bottom: sum of Adjusted Velocity × 0.80.

04

Add the sprint backlog as a linked database

Create a "Sprint Backlog" database with properties: Ticket ID (text), Title (title), Assignee (relation to Team Members), Story Points (number), Status (select: Not Started, In Progress, In Review, Done), and Sprint (relation to Sprint Capacity Plans). Embed a filtered view of this database in each sprint plan entry showing only tickets in that sprint. A rollup property on the Sprint Capacity Plans entry shows total committed points from linked backlog items.

05

Create a velocity trends gallery

Add a gallery or chart view to the Sprint Capacity Plans database showing Sprint Name, Committed Points (rollup from backlog), and Completed Points (rollup of Done tickets). Toggle between committed and completed to visualize the commitment accuracy trend over time. A gallery view filtered to the last 8 sprints becomes the velocity history artifact used in sprint planning conversations with stakeholders.

Common mistakes

Building formulas in the template instead of database properties

Capacity formulas built into a Notion template body (as manually calculated numbers) must be updated manually each sprint. Build the calculations as formula properties in the database schema — they recalculate automatically when related properties change. Template bodies should show the formula property results, not manual calculations.

Not linking the backlog to the capacity plan

A capacity plan and a sprint backlog maintained in separate Notion pages require manual reconciliation: "how many points have we committed so far?" Use Notion's relational database to link backlog tickets to the sprint plan. A rollup property on the sprint plan then shows committed points in real time as tickets are added to the backlog.

No sprint retrospective data captured in the system

Sprint capacity planning improves over time only if you capture actual completion data alongside planned data. Add a Completed Points rollup to each sprint plan entry (rollup of Done tickets in the backlog). The delta between Committed and Completed, tracked over 8+ sprints, reveals whether your velocity estimates and buffer assumptions are calibrated correctly.

Tips

Create a Notion formula that flags the sprint entry orange when committed points exceed 85% of recommended capacity — this visual warning during planning prevents overcommitment before the sprint starts

Use Notion's duplicate page feature to create each new sprint plan from the previous sprint's entry, pre-populated with the same team members. Update dates and PTO — the structure is already there.

Embed the capacity plan view in your team's home page with a filter for "Current Sprint" so the sprint commitment is visible without navigating to the database — this keeps capacity visible throughout the sprint, not just at planning

How Vantage helps

Sprint capacity planning in Notion calculates how much the team can commit. Vantage connects sprint capacity to the product backlog: Vantage-generated tickets include story point estimates and dependency information, so EMs can see which PRD requirements fit within the sprint capacity and which must be deferred. This replaces the manual process of estimating tickets from PRDs and comparing to a spreadsheet.

Frequently asked questions

Spend less time on setup, more on decisions

Vantage connects your tools and generates specs grounded in real data. Free to start.

Free to start. No credit card required.

Related reading