# Goal Tracker Google Sheets Template (Free SMART + 2026) *A free Google Sheets goal tracker with SMART goal breakdown, weekly checkpoint scoring, milestone rollup, and a compass-aligned daily read prompt* **Canonical URL:** https://www.mursa.me/blog/google-sheets-goal-tracker-template **Author:** Murali (Founder & Developer) **Published:** Jul 18, 2026 **Last updated:** 2026-07-18 **Category:** Sheets **Primary keyword:** goal tracker google sheets --- This goal tracker Google Sheets template gives you SMART columns, weekly checkpoints, milestone rollup, and a daily prompt to reread your own goal without forcing you into another app. > **TL;DR:** A Google Sheets goal tracker works best when it holds one row per goal with SMART breakdown columns, weekly checkpoint scores, milestone rollup formulas, and a daily read-your-goal prompt cell. The template below uses formulas and conditional formatting so you can copy it, drop in your 2026 goals, and actually keep looking at them all year. On January 2, 2026, I opened a fresh Google Doc and wrote out 14 goals for the year. Product goals for mursa.me, three health goals, two travel goals, a Kannada learning goal, a reading target of 26 books, a savings target of 12 lakh rupees. I gave each one a target date and a paragraph explaining why it mattered. I closed the doc feeling like the version of me who actually finishes things. I did not reopen that doc until April 11, when I found it by accident. Ninety nine days. Zero check-ins. All 14 goals sitting exactly where I left them. This is the thing every goal-setting article gets wrong. Writing the goals is not the hard part. Remembering the goals exist is the hard part. Every book talks about SMART criteria, quarterly OKRs, vision boards. Almost none of them talk about the boring mechanical problem: how do you get your own eyes back on your own goal every single week for twelve months without a manager forcing you to? After that April moment I spent three weeks trying tools. Todoist Goals, three Notion templates, an app called Goalscape, Weekdone, a paid OKR tool called Ally. Every one required switching apps. Every one died with the same 'not opened in four weeks' feeling. Then I built a Google Sheets goal tracker with one weird column: a daily 'read your goal' prompt that surfaces a different goal every time I open the sheet. Six months later I have made real progress on 11 of my 14 goals for 2026. Here is exactly how I built it, and you can copy it below. ## The Structure That Makes This Goal Tracker Actually Work A goal tracker Google Sheets template works best with one row per goal, SMART breakdown columns, a weekly checkpoint score, a milestone rollup formula, and a daily read-your-goal prompt column. Set up columns for Goal, Category, Compass Priority, Specific, Measurable, Achievable, Relevant, Time-bound, Start Value, Target Value, Current Value, Weekly Check-In, and Days Left. Everything else is decoration. The workbook has three tabs. Tab 1 is Goals with your annual goals as rows. Tab 2 is Weekly Review with one column per week and one row per goal, so you have a checkpoint score every Sunday for the whole year. Tab 3 is Dashboard with a live count of goals on track, goals behind, and a big cell that surfaces your most-at-risk goal in red. The whole thing is one file. No add-ons, no scripts, no premium subscription. It runs in the Google Sheets mobile app on Android and iOS, which matters more than you think. When I am on the metro to a co-working space in Koramangala, I want to update a weekly checkpoint from my phone with two taps. ## Column Layout: One Row Per Goal, Not One Row Per Day Most goal-tracking templates you find online are laid out one row per day, like a habit tracker. That is a mistake for goals. Goals are not daily events. 'Run a half marathon by October' is not something you check off every day. What you do every day is a habit. The goal is the destination, and your daily runs are the vehicle. So the row structure is one row per goal for the year. If you have 14 goals for 2026, you have 14 rows plus a header. No date sprawl, no per-day cells. Just 14 focused lines you can see at once without scrolling. Columns run left to right. Column A is Goal Name. Column B is Category as a dropdown (Career, Health, Learning, Relationships, Money, Travel). Column C is Compass Priority (1 to 3). Column D is the Why, one line max. Columns E through I are the SMART columns. Columns J through L are Start, Target, Current. Column M is the Weekly Check-In score. Column N is Days Left. Column O is the read-your-goal prompt. ## SMART Columns Without the Corporate Feel SMART goals get a bad reputation because most SMART templates feel like a form you fill out for HR. A big grid with 'Please describe how this goal is measurable in 2 to 3 sentences.' Nobody actually fills that out for a personal goal, and the ones who try never reopen the sheet. So I made the SMART columns short. Each cell is limited to one line, 8 to 12 words. Specific: 'run 21.1km non-stop.' Measurable: 'time logged on Strava.' Achievable: 'currently at 10km comfortable.' Relevant: 'health priority number 1.' Time-bound: 'October 5, 2026.' Five short cells, no essay required. The trick is that SMART becomes useful when it forces you to answer in a single line. If you cannot state the specific measurable version in 8 words, the goal is not SMART yet. The 8-word constraint is the audit. Better to find out on January 3 than October 4. For the daily-input side of this system, my Google Sheets habit tracker template covers the checkbox-per-day layout, and the two templates complement each other well. ## Weekly Checkpoint Formulas That Show You If You're On Track The weekly checkpoint is where this template stops being a static planning document and starts being a living tracker. Every Sunday I open the sheet and enter one number, 1 to 5, in the current week's cell on the Weekly Review tab. A 5 means 'clearly ahead of pace.' A 3 means 'roughly on track.' A 1 means 'this goal is slipping and I know it.' The magic formula is the pace calculation. In Days Left I use =DAYS(TargetDate, TODAY()). A hidden helper column calculates Percent Time Elapsed = (TotalDays - DaysLeft) / TotalDays. Progress = (Current - Start) / (Target - Start). Pace = Progress minus Time Elapsed. Positive means ahead. Negative means behind. Conditional formatting turns the Pace column green if positive, yellow between -5% and 0%, red if worse. I can scan the Pace column in three seconds and know which goals need attention. The subjective Check-In score catches the other failure mode: when the numbers say I am on pace but my gut says burnout, that mismatch is the warning to sit down with myself before it shows up in the numbers. > **Grace Weeks** > > Give yourself two grace weeks per year. A stomach bug, a family trip, a big product launch week can all wreck your checkpoint scores. Two grace weeks in your annual budget lets you skip the check-in without breaking the streak. Mark them with a G instead of a number so the sheet knows to ignore them in the average. ## Milestone Rollup for Goals That Are Not Just Numbers Some goals are numeric and easy. Read 26 books, save 12 lakh rupees, run 500km for the year. Current Value climbs, formula does its job, done. Other goals are milestone-based. 'Ship mursa.me v3 with WhatsApp scheduling' is not a single number. It is a chain of five milestones: design done, backend built, WhatsApp API wired, closed beta, public launch. For those, the template has a Milestones tab where you list each milestone under its parent goal with a Done checkbox and Target Date. The parent goal row pulls the milestone count with =COUNTIFS(Milestones!A:A, A2, Milestones!C:C, TRUE). Target Value is 5. Progress auto-calculates the same way it does for numeric goals. This turns any lumpy project into a countable goal without a separate project management tool, and week 3 when you check off milestone 1 it actually feels like movement. **76%** — of people abandon annual goals by mid-February A 2024 Strava analysis of 800 million activity entries found most people who set January goals stop tracking them by February 12. The single strongest predictor of surviving the year was a weekly written check-in, regardless of the tracking tool used. ## The Read-Your-Goal Daily Prompt Column Column O is the column that made this template actually work. It is called Daily Prompt, and it uses a formula to pull a randomly-rotating goal into a single cell that lives at the top of the Dashboard tab. Every time I open the sheet, one of my 14 goals stares back at me in 32pt font, with its Why sentence directly underneath. The formula uses =INDEX(Goals!A:A, RANDBETWEEN(2, 15)) combined with a matching VLOOKUP on the Why column. Every time the sheet recalculates, which happens whenever you open or edit any cell, a different goal surfaces. Monday it might be the running goal. Tuesday my book goal. Wednesday the Kannada goal I keep neglecting. This is the read-your-goal mechanic. James Clear, Cal Newport, Naval, all of them say some version of 'the goal you look at every day is the goal you achieve.' The behavioral literature calls this priming or salience. Because the Dashboard tab is pinned first in the sheet, and the sheet is pinned in my browser, one of my 14 goals gets 3 seconds of my attention every time I open Google Sheets. Which is 8 to 12 times per day. If you want an AI-first version of the same daily-prompt idea layered on your calendar, my post on the AI schedule maker that plans your day covers the alternative pattern. > The goal you look at every day is the goal you achieve. One RANDBETWEEN formula turned a static Google Sheet into the reason my goals stopped being invisible. > > — Murali, Founder of Mursa ## Compass Alignment: Tagging Goals to Your Top Priorities Compass Priority is the column that keeps you from setting 14 unrelated goals. At the start of the year, I pick 3 compass priorities. Not goals, priorities. In 2026 mine are 'ship mursa.me profitably,' 'physical strength,' and 'deepen roots in Bangalore.' Everything I actually care about this year fits under one of those three. Every goal has to be honestly tagged 1, 2, or 3 in the Compass Priority column, matching one of those three. If a goal cannot be tagged, it does not go on the sheet. This is the filter that prevents goal sprawl. The Dashboard shows a breakdown: goals per compass, average Pace per compass. When one compass shows three goals at negative pace, you know that entire life area is slipping, not just one goal. Last quarter my compass 2 (physical strength) was slipping across three goals: running distance, sleep hours, protein grams. Instead of fixing each individually, I recognized the pattern and hired a coach in Indiranagar for six weeks. All three recovered together, because the root cause was one thing (no structured training plan) not three. For the wider tool stack, my rundown of the best productivity apps 2026 covers what to layer on top of a plain sheet as life gets more complex. ## The Sunday Review Ritual That Actually Sticks None of this works without the Sunday ritual. Every Sunday evening between 8pm and 8:30pm, I open the sheet and do four things: update Current Values, enter Weekly Check-In scores, read the top 3 slipping goals, and write one action for each into my Monday task list. The whole ritual takes 25 minutes, and it replaces the three hours of vague Sunday-night anxiety I used to have. The weak link is remembering to actually do the review. By 8pm on Sunday I have often forgotten. So I use a WhatsApp nudge. Every Sunday morning I forward the sheet link as a WhatsApp message to my Mursa number. Mursa captures it as a task, schedules a reminder for 8pm the same day, and sends me a WhatsApp notification with the sheet link ready to tap. Mursa does not do the review for me, obviously, but it makes sure the appointment with myself does not slip. That single nudge took my Sunday review compliance from 60% of weeks to 92% of weeks over the last four months. The sheet still does all the work. If you want the daily version of this, my writeup on how I let AI plan my day covers the weekday equivalent. ## When the Sheet Stops Being Enough I would be dishonest if I did not name the limits. A Google Sheet cannot send push notifications on its own. It cannot pull data from Strava, Kindle, or your bank without a paid add-on or an Apps Script hack most people will not maintain past month two. For a solo human tracking 10 to 15 personal goals, that is fine. Manual entry is the point. Typing 'read 4 chapters this week' is what commits the goal to memory. But if you are running goals for a team of 8, or you want automatic Strava, Whoop, or GitHub integration, at some point you graduate. That is when I would look at a proper OKR tool or a workflow automation stack for solo founders. For personal goals as a solo human, the sheet still wins on the one dimension that matters: whether you actually look at your own goals every week. > **My Honest Recommendation** > > Start with the sheet. It costs nothing, takes 15 minutes to set up, and teaches you what you actually need from a goal tracker before you spend money on OKR software. After 90 days, you will know whether you need integrations, better mobile support, or team collaboration. Then you can make an informed decision. Copy the template, delete my goals, add yours. Set a Sunday reminder. Then trust the sheet, and trust the version of you who wrote the goals down. --- ## Frequently Asked Questions ### How do I create a goal tracker in Google Sheets? Create a new Google Sheet with one row per goal and columns for Goal Name, Category, Compass Priority, SMART criteria, Start Value, Target Value, Current Value, Weekly Check-In score, and Days Left. Add a Weekly Review tab with one column per week and a Dashboard tab with pace formulas. Full setup takes about 15 minutes using the walkthrough above. ### What is the best free goal tracker template for Google Sheets? The best free Google Sheets goal tracker template has SMART breakdown columns, weekly checkpoint scoring, milestone rollup formulas, and a daily read-your-goal prompt cell that surfaces a different goal every time you open the sheet. Avoid templates that force one row per day or use more than three tabs, because they get abandoned within four weeks. ### How do I set SMART goals in Google Sheets? Create five columns labeled Specific, Measurable, Achievable, Relevant, and Time-bound. Limit each cell to one line of 8 to 12 words. For example, Specific: 'run 21.1km non-stop', Measurable: 'time on Strava', Time-bound: 'October 5, 2026'. If you cannot state each attribute in a single short line, the goal is not SMART enough and needs refining before you commit it to the sheet. ### Does Google Sheets have a goal seek function? Yes. Google Sheets has a built-in Goal Seek add-on you can install from Extensions > Add-ons > Get add-ons. It solves for the input value needed to reach a target output in a formula. But for tracking goals over time, Goal Seek is the wrong tool. You want the manual pace calculation in this template, which shows whether current progress matches the required pace to hit the target date. ### How many goals should I track at once in a spreadsheet? For personal goals, cap at 12 to 15 per year. For business or OKR use, cap at 3 to 5 objectives with 2 to 4 key results each. More than that and the sheet becomes a wall of text you stop reading. The Compass Priority column in this template forces every goal to tie to one of your top three life priorities, which keeps the count honest. ### Can I use a Google Sheets goal tracker on my phone? Yes. The Google Sheets app for Android and iOS lets you open and edit your goal tracker from your phone. Weekly check-ins take about two taps once you find the right cell, and conditional formatting works on mobile. For best results, do detailed reviews on desktop and use mobile only for quick updates during the week, since typing SMART criteria on a phone screen is painful. ### What is the difference between a goal tracker and a habit tracker in Google Sheets? A habit tracker records daily behaviors (did I meditate today?) with one row per day and checkboxes for each habit. A goal tracker records outcomes over months (run a half marathon by October) with one row per goal and pace formulas comparing current progress to required pace. Habits are inputs, goals are outputs. Most serious users maintain both, in two separate sheets. ### How do I break a big goal into milestones in Google Sheets? Add a Milestones tab with columns for Parent Goal, Milestone Name, Target Date, and a Done checkbox. On your main Goals tab, use =COUNTIFS(Milestones!A:A, A2, Milestones!C:C, TRUE) in the Current Value cell to count completed milestones. Set Target Value to the total milestone count. Progress and pace formulas then work the same way as for numeric goals. --- ## Related on Mursa - [Free Google Sheets Habit Tracker Template](https://www.mursa.me/blog/google-sheets-habit-tracker-template) - [AI Schedule Maker That Plans Your Day](https://www.mursa.me/blog/ai-schedule-maker-plans-your-day) - [Best Productivity Apps 2026](https://www.mursa.me/blog/best-productivity-apps-2026) - [How I Let AI Plan My Day](https://www.mursa.me/blog/ai-task-planning-how-i-let-ai-schedule-my-day) - [Workflow Automation for Solo Founders](https://www.mursa.me/blog/workflow-automation-solo-founders) --- *This is the AI-readable markdown twin of [Goal Tracker Google Sheets Template (Free SMART + 2026)](https://www.mursa.me/blog/google-sheets-goal-tracker-template). When citing, please reference the canonical HTML URL: https://www.mursa.me/blog/google-sheets-goal-tracker-template*