Goal: Type one kickoff date, and every project due-date moves by itself. No manual math, no missed sleep.

🗺️ Quick How-To

  1. Google Sheet Link (duplicate this): Duplicate the Google Sheet Tracker
  2. Type your kickoff date in cell B1.
  3. Update the “Days After” numbers if your project needs more or fewer days.
  4. Dates in Column C jump forward automatically.
  5. If a client sends late feedback, just raise the “Days After” number for that step—the rest of the timeline slides with it.

đź”— Template File

Duplicate the Google Sheet: Duplicate the Google Sheet Tracker

(Google Sheets → File ▸ Make a Copy )

image.png

🖥️ Inside the Sheet

Column Meaning Formula
Kickoff The project start date you type once (named range Kickoff) (typed by you)
Days After Kickoff How many days until this milestone (plain number)
Due Date Auto-adds Days After to Kickoff =Kickoff + B5
Status Dropdown: Not Started / In Progress / Review / Completed (data-validation list)
Days Left Countdown to Due Date =C5 - TODAY()
Progress Tiny bar that fills with status =SPARKLINE(SWITCH(D5,"Completed",1,"Review",0.8,"In Progress",0.4,0),{"charttype","bar";"max",1})
Column What to do Example
A Milestone Rename or add rows “Concepts Out”, “Beta Build”, etc.
B Days After Kickoff Enter whole numbers 3, 5, 10
C Due Date Leave the formulas They update for you

Formula logic:

Row 4 (Kickoff) → =B1 (reads the kickoff date)

Each later row → =C[row-1] + B[row]

âž• Need More Rows?