Project Plan Template for Google Sheets
Project Plan Template for Google Sheets
An agile project plan in Google Sheets organized by sprint buckets instead of waterfall phases, with rolling scope and a velocity tracker built from formulas.
Free, ungated, opens in Google Sheets
- Sprint bucket tabs with capacity rows
- Backlog sheet with priority ranking column
- Velocity tracking row using SUM and AVERAGE formulas
- Release goal summary at the top
- Retrospective action items log
- Conditional formatting for status colors
How to Use This in Google Sheets
Make your own copy
Click Open in Google Sheets, then File > Make a copy. Your version saves to your Drive with all formulas and conditional formatting intact.
Set release goals and capacity
On the top summary row, type your release goal and each sprint’s capacity in story points. The capacity number drives the velocity comparison later, so set it honestly.
Rank the backlog
On the Backlog sheet, enter items and set a priority number in the ranking column. Select the column and use Data > Sort range to order the backlog top to bottom.
Pull items into sprint buckets
Copy the highest-priority backlog rows into the current sprint tab until you hit the capacity number. The points cell at the top of each bucket sums automatically and turns red if you overcommit.
Track velocity across sprints
As you close sprints, enter completed points in the velocity row. The AVERAGE formula updates your rolling velocity, which tells you how much to pull into the next sprint.
Who This Is For
Scrum and sprint-based teams
Teams that plan in iterations and want a plan shaped like their process, not forced into waterfall phases.
Google Workspace teams
Groups already living in Drive who want a plan everyone can open and edit without buying another tool.
Distributed teams editing together
Remote teams that need several people updating the same plan at once without version conflicts.
Frequently Asked Questions
Yes. Make a copy to your own Drive at no cost. It uses only native Google Sheets formulas and conditional formatting, so there is nothing to install or pay for.
Yes. Download it as .xlsx from File and the formulas carry over, since SUM and AVERAGE work identically. Conditional formatting usually transfers, though complex rules can need a quick check in Excel.
Yes. Enter completed story points in the velocity row as each sprint closes and the AVERAGE formula updates your rolling velocity, which guides how much to pull into the next sprint.