Sheetzy guide

How to Create a Tracker in Google Sheets That Actually Updates Itself

By Mani Dazzle, Template maker at Sheetzy · 21 November 2026

Decide what 'done' looks like before you touch a cell

Every tracker answers one question. Am I spending too much on groceries? Did I follow up with every lead this week? Have I actually been going to the gym? Write that question in cell A1 and let it decide everything else.

The question sets the unit you log: a rupee amount, a yes or no, a number of minutes. If a column does not help answer the question, delete it. Trackers fail from clutter far more often than from laziness.

The three columns almost every tracker needs

Column one: date. Always a real date, not a weekday name, because dates are what let you group by week and month later.

Column two: the item - the habit, the expense, the client, the task. Keep the wording consistent; 'Gym' and 'gym ' with a trailing space are two different things to a formula.

Column three: the value. For a habit it is a tick or a 1. For money it is an amount. For time it is minutes. One value type per tracker - mixing ticks and numbers in one column breaks every summary formula you will write.

Dropdowns stop typos before they happen

The silent killer of trackers is inconsistent entries: 'Groceries' one day, 'grocery' the next, 'Food' when you are in a hurry. SUMIF treats all three as strangers and your totals quietly lie.

Fix it with data validation. Select the column, go to Data, then Data validation, and add a dropdown with your exact categories. Entering a row becomes picking from a list - faster to do, impossible to misspell, and your summaries stay honest.

Let formulas do the maths you would otherwise skip

Three formulas cover most trackers. COUNTIF counts how many times something happened: how many gym days this month. SUMIF adds up one category: total grocery spend this week. And a simple percentage cell - done days divided by days so far - gives you the score that keeps you honest.

Put these in a small summary block at the top of the sheet, above the log. You should never have to scroll to know how you are doing. When the score is visible the second you open the sheet, updating the log stops feeling like admin and starts feeling like progress.

Conditional formatting is the gentle nudge

A tracker that only records is half a tracker. Use conditional formatting to make the sheet react: green when this week's count beats last week's, red when a spending category crosses its limit, amber when a follow-up date has passed.

Keep it to one or two rules. A sheet that lights up like a festival decoration trains you to ignore it; one red cell on an overdue item is impossible to unsee.

The weekly habit that keeps it alive

Attach the tracker to something you already do. Friday afternoon with the bank app open, Sunday evening with next week's calendar, the commute on the first of the month. Two minutes in a fixed slot beats a heroic catch-up session every time.

And when you miss a week - you will - just restart from today. Do not backfill invented rows; a tracker with guessed data is worse than a gap. If you would rather skip the setup entirely, our ready-made templates like the habit tracker and the wealth tracker have these columns, dropdowns and summary formulas pre-built, and the dashboard guide shows how to turn any tracker into charts once the data piles up.

Quick answers

What should I track in Google Sheets?

Anything with a repeating event you want to count or review: habits, expenses, jobs applied to, client follow-ups, workouts. The rule is one tracker per question. If you cannot say what question the sheet answers, it will not get updated.

How do I make a tracker update automatically?

Put the maths in formulas, never in your head. Totals, streaks and percentages should all be COUNTIF or SUMIF over your log column, so the only manual work is ticking the day. The moment you calculate anything by hand, the tracker starts dying.

Is Google Sheets good enough for tracking, or do I need an app?

For one person tracking one thing, Sheets is usually better than an app: no subscription, works offline on your phone, and you can change the structure any time. Apps win when you need push reminders or shared tracking with a group.

How many columns should a tracker have?

Fewer than you think. Date, the thing you are tracking, and one status or number column covers most trackers. Every extra column is a small tax you pay every single day, and that tax is what kills the habit.

Keep going

More from Sheetzy

Momentum habit tracker Google Sheets template on a tablet, dashboard with monthly progress

Momentum

Habit Tracker Spreadsheet Template

A full-year habit tracker that keeps score gently: daily ticks, weekly rhythm, monthly rollups and a year view that shows how far you have come.

₹358₹39810% OFF DIRECT
Details

All guides Browse the templates