DEV Community

Thesius Code
Thesius Code

Posted on • Originally published at datanest-stores.pages.dev

Sprint Planning Dashboard

Sprint Planning Dashboard

An agile sprint planning system built in Notion. Manage your product backlog, plan sprints with capacity-aware scoping, track velocity, run standups, and visualize progress with burndown-style tracking. Works for solo devs and small teams alike.

Key Features

  • Product backlog with priority scoring and effort estimation
  • Sprint planning board with capacity tracking and scope management
  • Velocity tracking across sprints for data-driven planning
  • Daily standup templates with yesterday/today/blockers format
  • Burndown tracking via remaining story points formula
  • Retrospective templates for continuous improvement
  • Epic and story hierarchy for organizing large initiatives

Database Schema

Backlog Items (Primary Database)

Property Type Description
Story Title Title User story or task description
Type Select User Story · Bug · Tech Debt · Spike · Chore
Status Select Backlog · Sprint Ready · In Progress · In Review · Done · Won't Do
Priority Select P0 - Critical · P1 - High · P2 - Medium · P3 - Low
Story Points Select 1 · 2 · 3 · 5 · 8 · 13 · 21
Epic Relation → Epics Parent epic
Sprint Relation → Sprints Assigned sprint
Assignee Person Who is working on this
Acceptance Criteria Text (long) Definition of done for this story
Labels Multi-select frontend · backend · api · database · infra · docs · testing
Created Date Created time When the item was added
Completed Date Date When it moved to Done
Blocked By Relation → Backlog Items Dependency on another item
Notes Text (long) Implementation notes and context

Sprints

Property Type Description
Sprint Name Title e.g., "Sprint 14 — Auth Overhaul"
Sprint Number Number Sequential sprint number
Status Select Planning · Active · Completed
Start Date Date Sprint start
End Date Date Sprint end
Duration Formula dateBetween(End Date, Start Date, "days")
Planned Points Rollup Sum of Story Points for linked items
Completed Points Rollup Sum of Story Points where Status = Done
Velocity Formula Completed Points (for completed sprints)
Completion Rate Formula round(Completed Points / Planned Points * 100)
Sprint Goal Text One-sentence sprint objective
Items Relation → Backlog Items All items in this sprint
Standup Notes Relation → Standups Daily standup records
Retro Relation → Retrospectives Sprint retrospective

Epics

Property Type Description
Epic Name Title Large feature or initiative name
Status Select Proposed · In Progress · Completed · Cancelled
Owner Person Epic owner
Target Quarter Select Q1 · Q2 · Q3 · Q4
Stories Relation → Backlog Items All stories under this epic
Story Count Rollup Total number of stories
Points Total Rollup Sum of all story points
Points Completed Rollup Sum of completed story points
Progress Formula round(Points Completed / Points Total * 100)
Description Text (long) Epic scope and objectives

Standups

Property Type Description
Date Title Standup date (auto-formatted)
Sprint Relation → Sprints Current sprint
Yesterday Text (long) What was accomplished yesterday
Today Text (long) What's planned for today
Blockers Text (long) What's blocking progress
Remaining Points Number Manual entry: points remaining in sprint
Team Mood Select Energized · Steady · Tired · Frustrated

Retrospectives

Property Type Description
Sprint Relation → Sprints Which sprint this reviews
Date Date When the retro was held
What Went Well Text (long) Positive observations
What Didn't Go Well Text (long) Problems and pain points
Action Items Text (long) Concrete improvements for next sprint
Team Rating Select 1 - Terrible · 2 - Poor · 3 - Okay · 4 - Good · 5 - Great

Quick Start

  1. Duplicate the template into your Notion workspace
  2. Populate your backlog — add 15-20 items with priority and story point estimates
  3. Create your first sprint — set a 2-week window, pull items from the backlog
  4. Set a sprint goal — one sentence describing what "done" looks like for this sprint
  5. Start daily standups — create a standup entry each morning

Usage Guide

Sprint Planning Process

1. Review backlog → Prioritize items, ensure estimates exist
2. Check velocity → Average of last 3 sprints = your capacity
3. Pull items → Drag from Backlog into Sprint until capacity is reached
4. Set sprint goal → One clear objective the team commits to
5. Kick off → Move sprint status to "Active"
Enter fullscreen mode Exit fullscreen mode

Velocity Tracking

Sprint Planned Completed Velocity Completion Rate
Sprint 11 34 29 29 85%
Sprint 12 31 31 31 100%
Sprint 13 33 27 27 82%
Average 33 29 29 89%

Use the 3-sprint average (29 points) to plan Sprint 14's capacity.

Recommended Views

View Type Filter / Group Use Case
Current Sprint Board Board Status groups, Sprint = Active Daily work
Backlog (Prioritized) Table Status = Backlog, sorted by Priority Sprint planning
My Tasks Table Assignee = Me, Status ≠ Done Personal task list
Epic Progress Table All epics with progress bars Roadmap overview
Velocity Chart Table All completed sprints Capacity planning
Burndown Log Table Standups for active sprint Daily progress tracking

Template Examples

Example: User Story

Field Value
Story Title As a user, I can reset my password via email
Type User Story
Priority P1 - High
Story Points 5
Epic Authentication Overhaul
Acceptance Criteria 1. Reset link sent within 30s 2. Link expires after 1h 3. Password validation enforced

Example: Sprint Entry

Field Value
Sprint Name Sprint 14 — Auth Overhaul
Sprint Number 14
Status Active
Start Date 2025-12-02
End Date 2025-12-13
Planned Points 29
Sprint Goal Complete password reset and OAuth integration

Customization Tips

  • Add a "Story Points Remaining" formula to Sprints for burndown calculations
  • Create a "Carry-over" checkbox on Backlog Items for stories that spill across sprints
  • Add "Definition of Ready" checklist as a template inside each backlog item
  • Build a "Sprint Comparison" table showing velocity trends over the last 6 sprints
  • Add an "External Dependency" text property for items blocked by other teams
  • Create a "Release Notes" view filtering Done items across recent sprints for changelog drafting

This is 1 of 11 resources in the Notion Developer Pro toolkit. Get the complete [Sprint Planning Dashboard] with all files, templates, and documentation for $19.

Get the Full Kit →

Or grab the entire Notion Developer Pro bundle (11 products) for $99 — save 30%.

Get the Complete Bundle →


Related Articles

Top comments (0)