Why Track OKRs in Google Sheets
Most teams that adopt OKRs end up tracking them in three places at once: a slide deck for the kickoff, a Notion page that goes stale by week 4, and Slack threads with the actual numbers. None of those work.
Google Sheets fixes the failure mode. One file, one source of truth, formulas that calculate score and confidence on a schedule the team can keep. No new tool to onboard. Anyone with the link can read it.
This guide walks through building an OKR tracker in Google Sheets that handles both quarterly and annual cycles, with 0.0-1.0 scoring and confidence levels. If you want to skip the build and copy a working version, the free OKR Template is a Google Sheets file with everything below pre-built. If you also need a strategy/roadmap layer, pair this with our Google Sheets roadmap template guide.
For the underlying methodology, the OKR walkthrough for Google Sheets users covers writing strong key results, and the OKR Generator helps draft them quickly.
Step 1: Set Up Three Tabs
Three tabs is the right number for an OKR tracker:
- Annual OKRs: Top-level company or product OKRs for the year
- Quarterly OKRs: This quarter's objectives and key results, scored weekly
- Check-ins: Week-over-week confidence and progress notes
Add a fourth tab called Archive if you want a record of past quarters. Most teams skip it for the first year and add it later.
Step 2: Build the Annual OKRs Tab
Annual OKRs are the strategic anchor. Quarterly OKRs should ladder up to them. Without an annual layer, quarterly OKRs drift into busy work.
Columns:
| Column | Purpose | Example |
|---|---|---|
| Year | Calendar year | 2026 |
| Owner | Executive or function lead | "Sarah (CPO)" |
| Objective | Qualitative goal | "Become the default tool for early-stage PMs" |
| Key Result | Quantitative target | "Hit 10K monthly active users" |
| Baseline | Starting value | 2,400 |
| Target | Year-end value | 10,000 |
| Current | Latest reading | 4,800 |
| Progress | Calculated % | 31.6% |
| Score (0.0-1.0) | Calculated | 0.32 |
| Confidence | Owner's belief | 6/10 |
The Progress formula:
=(Current - Baseline) / (Target - Baseline)The Score formula clamps Progress between 0.0 and 1.0:
=MIN(1, MAX(0, (Current - Baseline) / (Target - Baseline)))Format the Score column as a number with one decimal place. The 0.0-1.0 scale comes from the original Google OKR system. A score of 0.7 is success. A score of 1.0 means the target was not ambitious enough.
If you are setting OKRs for the first time, the OKR resources list and the OKR-related glossary terms cover the fundamentals before you start scoring.
Step 3: Build the Quarterly OKRs Tab
Quarterly OKRs are where the work happens. Same columns as annual, plus a few extras:
| Column | Purpose | Example |
|---|---|---|
| Quarter | Q1, Q2, Q3, Q4 | "Q2 2026" |
| Owner | PM or team lead | "Alex" |
| Parent Annual OKR | Which annual KR this rolls up to | "Hit 10K MAU" |
| Objective | Qualitative goal | "Drive activation in self-serve flow" |
| Key Result | Quantitative target | "30% trial-to-paid conversion" |
| Baseline | Starting value | 18% |
| Target | End-of-quarter value | 30% |
| Current | Latest reading | 22% |
| Score | Calculated | 0.33 |
| Confidence | Owner's belief | 7/10 |
| Status | On Track, At Risk, Off Track | "On Track" |
Map confidence to status
Use a formula in the Status column to derive status from confidence and progress automatically:
=IF(K2 >= 7, "On Track", IF(K2 >= 4, "At Risk", "Off Track"))Where K2 is the Confidence column. Apply conditional formatting to color the Status column:
- On Track → Green
- At Risk → Yellow
- Off Track → Red
This gives you a one-glance read on the quarter without parsing every row.
Set confidence at kickoff, update weekly
At the start of the quarter, every key result should have a confidence of 5/10. That is the honest answer when you have not started yet. Update confidence weekly during check-ins, not when you remember.
If a key result is at 9/10 confidence in week 2, the target was not ambitious enough. The point of OKRs is to push, not to manufacture wins.
Step 4: Build the Check-ins Tab
The check-ins tab is the discipline layer. Without it, the tracker dies in week 4.
Set up one row per OKR per week:
| Column | Purpose | |
|---|---|---|
| Week | Week-of date | "2026-05-12" |
| OKR ID | Matches the Quarterly OKRs row | "Q2-1" |
| Confidence | This week's reading | 6/10 |
| Progress | Updated current value | 24% |
| Note | One-line update | "Hit conversion test, rolling out next week" |
| Blocker | Anything in the way | "Waiting on data team for cohort def" |
The Confidence column should be a dropdown (Data > Data validation, range 1-10). The Note column is free text but should be one sentence. If you cannot summarize the week in one sentence, you do not understand the state.
Plot confidence over time
Insert a chart (Insert > Chart) on this tab with Week on the X-axis and Confidence on the Y-axis, one line per OKR. A confidence line that drops 3+ points over 2 weeks is the early signal that something is wrong. The point of weekly check-ins is to catch that signal in week 4, not week 12.
For teams that already use continuous discovery habits, pair this tab with the weekly insight review. New customer signals often shift confidence before metrics do.
Step 5: Score the Cycle
At the end of the quarter, lock the scores. The 0.0-1.0 scale interprets like this:
| Score | Meaning |
|---|---|
| 0.0-0.3 | Missed. Investigate root cause. Not necessarily a failure if you learned. |
| 0.4-0.6 | Partial progress. Most key results land here. |
| 0.7 | Success. The target was the right level of ambition. |
| 0.8-1.0 | The target was too easy. Set harder ones next quarter. |
A team-level grade is the average of all key result scores in the quarter:
=AVERAGE(QuarterlyOKRs!I:I)Most healthy teams average 0.5-0.7 across a quarter. Below 0.5 sustained over multiple quarters means the team is overcommitting at planning. Above 0.7 sustained means the team is sandbagging.
Tie OKRs to roadmap items
Add a column on your roadmap that maps each initiative to a key result. The goals-based roadmap format does this natively, and the Goals Roadmap Template has the structure pre-built. When OKRs and the roadmap connect, prioritization arguments end faster. Anything not on a key result is, by definition, not a priority for the quarter.
Step 6: Run the OKR Cadence
Build the cadence into your team calendar:
- Quarter kickoff (90 min): Draft objectives, write key results, set baselines, set targets, set initial confidence at 5/10. Use the OKR Generator to speed up the drafting.
- Weekly check-in (15 min): Update the Check-ins tab. Confidence reading, current value, one-sentence note. No discussion of strategy. That is for the monthly.
- Monthly review (45 min): Review the trend lines on the Check-ins tab. Anything trending below 4/10 confidence gets a recovery plan or a re-scope.
- Quarter close (60 min): Lock the scores. Review what hit 0.7 and what did not. Feed the lessons into next quarter's drafting.
The biggest failure mode is skipping the weekly check-in. A monthly cadence is too long. By the time you notice an OKR is off track, six weeks have already burned. The 15-minute weekly check-in is the only ritual you cannot skip.
For drafting OKRs alongside the strategy, see the OKR resources list for templates and methodology. The OKR Tracker tool is the hosted version of the Google Sheets approach if you outgrow the spreadsheet.
When to Move Beyond Google Sheets
A spreadsheet OKR tracker works for teams up to about 100 people running quarterly OKRs at 2 levels (company + team). Beyond that, you will hit:
- Manual rollup from team OKRs to company OKRs
- Confidence trend lines need to be charted across many sheets
- Dependencies between OKRs from different teams cannot be modeled
If those frictions are real, the PM Tool Picker covers dedicated OKR platforms. Most teams find that even after switching tools, they keep a Google Sheets backup for executive presentations because slides paste cleaner from a spreadsheet than from a SaaS dashboard.
Related
- How to Create OKRs in Google Sheets
- 8 Free Google Sheets Roadmap Templates
- Agile Roadmap in Google Sheets: Free Templates
- Top OKR Resources for Product Teams
Sources
- "Measure What Matters" by John Doerr (Penguin, 2018)
- Google's re:Work guide to OKRs (rework.withgoogle.com)
- Google Sheets formula reference (Google Workspace Learning Center)