A habit tracker in Google Sheets that counts your streak
Short answer
Put the days of the month across row 1 and one checkbox per day in row 2 (Insert > Checkbox). In row 3, a running count adds 1 when the day is checked and resets to 0 when it isn't: B3 =IF(B2,1,0), C3 =IF(C2,B3+1,0), dragged right. The number under today is your current streak and =MAX(B3:AF3) is your best.
Copy-paste code
One habit per pair of rows
B3: =IF(B2, 1, 0)
C3: =IF(C2, B3 + 1, 0) then drag C3 right to AF3
Best streak: =MAX(B3:AF3)
Done this month: =COUNTIF(B2:AF2, TRUE)
Completion %: =COUNTIF(B2:AF2, TRUE) / DAY(TODAY())Good to know
Start with three habits at most, each with a tiny version that counts on bad days (one page of reading, a 10-minute walk).
Conditional formatting (green when TRUE) makes the month readable at a glance.
Streakwren Tracker Set: Habits, books and goals you actually keep
from $15Streakwren is three ready workbooks (habits, reading and goals) for Excel and Google Sheets, with yearly views and monthly charts.
Secure checkout · 14-day fix-or-refund if it doesn't work as described (terms)Questions
What should I track?
Things you do daily and can say yes or no to: reading, exercise, sleep by a set time, no phone in bed.
Can I use this on a phone?
Yes, checkboxes work in the Google Sheets app.
Free: the Free Planner Sampler
4 printable previews (budget, debt payoff, focus planner, habit tracker), then 5 short emails with formulas that make a budget stick.