30/60/90 Sprint Tracker (Spreadsheet Template)

Purpose

This spreadsheet template keeps a 90-day transformation journey organized and visible across three sequential 30-day sprints. Use it to capture sprint goals, owners, experiments, tasks, status, baseline vs current metrics, risks, and retrospective learning so that improvements persist and scale.

How to use this template

1. Create three tabs (30, 60, 90) plus the supporting tabs described below. Each sprint tab focuses on goals, experiments, tasks, and outcomes for that 30-day window.
2. Keep one Sprint overview tab that lists the sprint goal, success criteria, owner, key metrics, and top experiments for that sprint.
3. Use the Task board tab for day-to-day task tracking. Link tasks to the sprint overview with a SprintID field.
4. Populate the Metrics dashboard tab with baseline and current values, a calculation of delta and percentage change, and a visual indicator of progress toward the sprint success criterion.
5. Log blockers in Risks & blockers and capture learning in Retrospective notes at the end of each 30-day cycle.

Tab-by-tab detail and suggested columns

Sprint overview (one row per sprint)

Suggested columns:

• SprintID (30/60/90)
• Sprint start / end
• Goal / Hypothesis
• Success criteria (measurable)
• Owner(s)
• Key metrics (link to Metrics dashboard)
• Top 2–4 experiments
• Status (On track / At risk / Off track)
• Outcome summary

Task board

Suggested columns:

• TaskID
• SprintID
• Task description
• Owner
• Priority (High/Med/Low)
• Planned start / due date
• Status (Not started / In progress / Blocked / Done)
• Percent complete
• Linked experiment
• Notes / outcome

Metrics dashboard

Suggested columns and calculations:

• Metric name
• Baseline (value at sprint start)
• Current (live update)
• Delta (Current - Baseline)
• Percent change (if applicable)
• Target / Success threshold

Example formulas (Excel/Sheets):

• Delta: =C2 - B2
• Percent change: =IF(B2=0, "—", (C2-B2)/ABS(B2))
• Progress indicator: =IF(C2>=E2, "Met", "Not met")

Risks & blockers

Suggested columns: RiskID, SprintID, Description, Impact (High/Med/Low), Likelihood, Owner, Mitigation, Status, Date opened/closed.

Retrospective notes

Use short, structured entries for each sprint. Suggested fields: What worked, What didn't, Key metrics & learnings, Decisions, Next experiments, Who is responsible for follow-up.

Conditional formatting rules (recommended)

• Task status: Green for Done, Yellow for In progress, Red for Blocked.
• Due dates: Highlight cells red when TODAY() > due date and percent complete < 100%.
• Metric traffic light: Green when metric meets/exceeds target, amber within 10–20% of target, red otherwise.
• Owner overdue count: Use a COUNTIFS per owner to flag owners with multiple overdue items (helps accountability).

Example conditional rule (Sheets/Excel): Format cell red when: =AND($H2<>"Done", $G2 < TODAY()) where G is due date and H is status.

Example Task row (illustrative)

Recommended metrics & examples

• Experiment success rate (number of experiments meeting success criteria / total experiments)
• Mean time to decision (days between problem identified & decision made)
• Adoption rate (percentage of team using new practice/tool)
• Customer or outcome metric tied to sprint goal (e.g., % defect reduction)

Retrospective prompts (quick template)

1. Goal & outcome: Did we meet the success criteria?
2. Evidence: Which metrics moved and by how much?
3. What helped: Team actions, tools, decisions that accelerated progress.
4. What held us back: Risks, blockers, resource gaps.
5. Decisions & next experiments: What will we try next sprint and who owns it?

Tailoring guidance

For small teams: keep columns lean and run brief weekly check-ins. For larger organizations: add fields for department, stakeholder, cross-team dependencies, and escalate unresolved blockers to a higher-level tracker.

Operational tips

• Keep this master template in a shared drive and copy for each 90-day journey so teams can adapt without modifying the master.
• Periodically (monthly) roll up sprint outcomes into a portfolio view to prevent orphaned pilots and competing metrics.
• Use consistent owner naming so COUNTIFS and pivot tables work reliably.

Next steps and integrations (capability-aware suggestions)

This static template works well as an initial tool. Consider these platform enhancements to increase value:

• Render an interactive Task board in THE so owners can update status in-platform (requires Interactive Form Rendering and Data Submission capabilities).
• Capture sprint submissions and retrospectives via the platform's form endpoint for audit history and analytics.
• Package the tracker as part of a Build Smarter Organization toolkit so teams can copy, tailor, and version their own 90-day journeys.

File & distribution notes

Provide this template as an .xlsx and a Google Sheets copy. Include a readme sheet with owner conventions and a change log when you publish copies to teams.