Habit Tracker in Google Sheets: Daily Checkboxes, Percentages and Charts
How to build a monthly habit tracker in Google Sheets with checkboxes, completion percentages and in-cell progress bars, plus which habits to start with.
Efficiency Sheets ·
A habit tracker works because it makes progress visible. One tick a day is small, but a month of ticks in a row is hard to break. Google Sheets is a good home for one: it's free, it works on your phone, and it can do the maths and charts for you.
The layout
- Column A: the habit ("Drink 8 glasses of water", "Read 20 pages")
- Column B: your goal for the month, in days (for example 25)
- Columns C to AG: one checkbox column for each day, 1 to 31
Select C2 to AG10 and use Insert → Checkbox.
The formulas
Days completed for a habit:
=COUNTIF(C2:AG2,TRUE)
Progress toward the monthly goal:
=COUNTIF(C2:AG2,TRUE)/B2
A progress bar in the cell next to it:
=SPARKLINE(COUNTIF(C2:AG2,TRUE)/B2,{"charttype","bar";"max",1})
How many habits you completed on a given day (put this under each day's column):
=COUNTIF(C2:C10,TRUE)
Your overall completion rate for the month:
=COUNTIF(C2:AG10,TRUE)/SUM(B2:B10)
Make it easy to read
Use Format → Conditional formatting to shade a day's column when every habit is done, or to colour a habit's row green-to-red by its percentage. The faster you can see how you're doing, the more often you'll open it.
Habits worth starting with
- Drink 8 glasses of water
- Move for 30 minutes
- Read 10 pages
- No phone for the first 30 minutes of the day
- In bed by a set time
- Log your spending
Pick ones that take under 30 minutes. Small habits that happen every day beat big ones that happen once a week.
Questions
How many habits should I track?
Start with three to five. Tracking too many at once makes it easy to give up on all of them.
What's a good completion rate?
Aim for around 80%. Perfect months are rare, and missing a day doesn't undo the habit as long as you don't miss two in a row.
Can I use it on my phone?
Yes. Checkboxes work in the Google Sheets app, so you can tick habits off wherever you are.
Should I start a new sheet every month?
Keep one tab per month in the same file. You can compare months side by side and see which habits stuck.
The Habit Tracker
$13.97 · one-time · instant download