Google Sheets offers product managers a free, accessible way to build OKR tracking systems without learning new software or managing additional subscriptions. Its collaborative features and formula capabilities make it suitable for teams just starting with OKRs or those operating with minimal budgets. Whether you're working solo or coordinating across departments, this guide walks you through setting up a functional OKR framework in less than an hour.
Why Google Sheets
Google Sheets removes friction from OKR adoption. Unlike specialized tools that require lengthy onboarding, you can start tracking objectives and key results immediately using a platform your team already knows. The real-time collaboration features mean your entire organization can view progress simultaneously, and you can grant different permission levels to different team members without complexity.
The flexibility of Sheets also matters. You're not locked into predefined views or limited by someone else's template structure. As your OKR practice matures, you can modify column headers, add custom formulas, and create specialized views for different stakeholder groups. For teams practicing OKRs for the first time, this adaptability helps you discover what works for your specific context before investing in dedicated software.
Step-by-Step Guide
Step 1: Create a New Google Sheet and Set Up Your Column Headers
Open Google Drive and create a new Google Sheet. Name it something clear like "Q4 2024 OKRs" or "Company OKRs 2025". The filename should include the timeframe so you can maintain historical records and compare performance across quarters.
Start with these column headers in your first row:
- Column A: Team/Owner
- Column B: Objective
- Column C: Key Result
- Column D: Target Value
- Column E: Current Value
- Column F: Progress (%)
- Column G: Status
- Column H: Notes
- Column I: Last Updated
Format the header row by selecting row 1, then applying bold formatting (Ctrl+B on Windows, Cmd+B on Mac) and adding a background color. Click Format in the menu bar, select "Conditional formatting", choose "Format rules", then pick "Single color". Use a light gray or your company color to make headers visually distinct from data rows.
Step 2: Add Your Company-Level Objectives
In Column B, list your company's main objectives for the quarter. Each objective should be directional and motivating, answering the question "what do we want to achieve?" Examples might be "Increase user engagement" or "Improve platform reliability". Limit yourself to 3-5 company-level objectives to maintain focus.
For each objective, add 2-4 key results in Column C. Key results are measurable outcomes that indicate whether you've achieved the objective. Under "Increase user engagement," you might have key results like "Daily active users grow 25%" or "Average session duration increases from 8 to 12 minutes".
In Column D (Target Value), enter the numeric goal. In Column E (Current Value), enter the starting point. The key result "Daily active users grow 25%" might have a target value of 125,000 (if you started at 100,000) and a current value of 100,000 initially.
Step 3: Create Progress Percentage Formulas
Click on cell F2 (the Progress column for your first key result). Enter this formula to calculate progress toward the goal:
=IFERROR((E2-E2)/(D2-E2),0)
This formula calculates what percentage of the distance from start to target you've covered. If your target is 125,000 daily active users and you started at 100,000, and you're currently at 110,000, the formula returns 40% (10,000 of 25,000 achieved).
Copy this formula down the entire F column by selecting F2, copying it (Ctrl+C), then selecting the range F3 through F100 and pasting (Ctrl+V). For cases where your current value exceeds your target value (like if your target was to reduce bugs and you went below your goal), this formula still calculates correctly.
For key results where lower is better (like reducing load time from 4 seconds to 2 seconds), you'll need to adjust the formula. Click in the appropriate cell and use:
=IFERROR((E2-D2)/(E2-D2),0)
This reverses the calculation so that achieving a lower number still shows progress. Test your formula with sample data before rolling it out across all rows.
Step 4: Set Up the Status Column with Conditional Formatting
The Status column (Column G) should show whether each key result is on track, at risk, or off track. You'll enter this manually each update cycle based on your assessment. Create a dropdown menu for consistency.
Click on the column G header to select the entire column. Go to Data in the menu bar, select "Data validation", then choose the option "List of items". Enter three items separated by commas: On track, At risk, Off track. Click "Show warning" or "Show suggestion" depending on your preference, then save.
Now add conditional formatting to color-code these statuses. Select column G again, go to Format > Conditional formatting. Create three rules:
- Format cells equal to "On track" with green background
- Format cells equal to "At risk" with yellow background
- Format cells equal to "Off track" with red background
This visual system helps you and your stakeholders quickly identify which areas need attention.
Step 5: Add Team and Owner Information
In Column A, specify which team owns each objective. Use consistent naming (Engineering, Product, Sales, Marketing, etc.). If using OKRs for individual contributors, you might use names instead. This helps with accountability and makes it clear who should update each row.
For sheets with many teams, you can create a separate tab for each team's OKRs. Click the "+" button at the bottom of the sheet to add new tabs. Name them "Engineering OKRs," "Marketing OKRs," etc. This keeps the company-level sheet clean while allowing team-specific detail.
Step 6: Create a Summary Dashboard Tab
Add a new tab called "Dashboard" or "Executive Summary". This becomes your at-a-glance view of overall progress. In this tab, create a simple table that pulls data from your main OKR sheet using formulas.
For example, in cell B2 of your Dashboard tab, you might create a formula that counts how many key results are "On track":
=COUNTIF('Q4 2024 OKRs'!G:G,"On track")
Create similar formulas for "At risk" and "Off track" counts. Add another formula to calculate the average progress percentage across all key results:
=AVERAGE('Q4 2024 OKRs'!F:F)
This dashboard becomes the version you share with executives who want a quick status without reviewing every individual key result.
Step 7: Set Up a Weekly Update Schedule
Add a column for "Last Updated" (Column I) and train your team to update this field whenever they modify current values. You can use a simple formula or just have people manually enter the date.
Create a separate "Tracking Log" tab where you record weekly snapshots of progress. Each week, copy the Current Value and Progress columns from your main sheet and paste them as values into the Tracking Log tab. This creates a history so you can see not just where you are, but the trajectory of progress.
Structure your Tracking Log with columns like: Week, Objective, Current Value, Progress %, and Notes. This becomes invaluable at quarter-end when you're evaluating outcomes and planning the next quarter.
Step 8: Share and Set Permissions
Once your sheet is set up, click Share in the top right. Add your team members' email addresses and assign appropriate permissions. Team leads who update their own OKRs should have Editor access. Stakeholders who only need to view progress can have Viewer access.
For company-level OKRs that multiple people might update, restrict Commenter access to prevent accidental changes. Only your OKR owner and perhaps your CPO should have full Editor permissions for the main columns.
Pro Tips
- Use comments for context instead of cluttering the Notes column. Right-click any cell and select "Insert note" to add context about why a key result is at risk or to capture discussion points. This keeps your spreadsheet clean while preserving important information.
- Create a simple red-yellow-green scoring system in your Dashboard. Use COUNTIF formulas to automatically count how many key results fall into each status category. This gives you one number to track each week: the count of items needing attention.
- Link to your roadmap from the Notes column. Include URLs to related documents, Jira epics, or planning documents. Your OKRs should connect to the actual work, and hyperlinks create that bridge.
- Duplicate your sheet at quarter-end rather than deleting old data. Rename last quarter's sheet to "Q3 2024 OKRs (Final)" and create a fresh sheet for the new quarter. This lets you compare performance year-over-year and learn from what actually happened versus what you planned.
- Assign one person as the OKR coordinator. Even in small organizations, having someone responsible for updating the Dashboard, scheduling review meetings, and maintaining the sheet prevents it from becoming stale. This person should spend perhaps 2-3 hours per week on OKR administration.
When to Upgrade to a Dedicated Tool
Google Sheets works well for teams with fewer than 20 people and fewer than 50 total OKRs across the organization. Once you scale beyond that, consider moving to dedicated OKR software. Look at our PM tools directory for alternatives that integrate with your existing systems.
Dedicated tools shine when you need cross-functional dependency mapping, automated reminder systems, or detailed access controls. If you find yourself managing OKRs across multiple departments and struggling to see how Engineering OKRs relate to Sales OKRs, it's time to upgrade. Also consider moving when you need audit trails showing who changed what and when, or when you want built-in integration with calendar systems for scheduled check-ins.
For more on OKR frameworks and when to adopt different approaches, see our guide to OKRs. If you're deciding between different tools as you scale, check our comparison of Airtable vs Notion for insights on how those platforms compare for planning work.