productivity
AI Writing Assistants
So what even is an AI writing assistant? Think of it like a very well-read friend who has absorbed an enormous amount of …
productivity
Tutorial
How to Build a Habit Tracker in Google Sheets
Jun 03, 2026 · 2 min read
A simple habit tracker in Google Sheets takes about 10 minutes to build and works better than most apps — you own the data, it’s always accessible, and you can customize it exactly how you want.
What you’ll have by the end: A color-coded habit tracker you can use every day.
Go to sheets.google.com and click the + to create a blank sheet. Name it something like “Habits 2026”.
In row 1, starting from column B, add the dates for the month (B1 = June 1, C1 = June 2, etc.). You can type the first two dates and drag the fill handle to auto-complete.
In column A, starting from row 2, list your habits — one per row:
- Exercise
- Read 20 minutes
- No phone before 9am
Select all the cells where you’ll log your habits (B2 through the last date column and last habit row).
Go to Insert → Checkbox. Each cell now has a checkbox that stores TRUE/FALSE.
Select the checkbox cells. Go to Format → Conditional formatting.
- Add a rule: if cell is checked (TRUE) → fill green
- Add another: if cell is not checked (FALSE) → fill light red
Now completed habits turn green and missed ones show red at a glance.
In the column after your last date, add a formula to see your monthly completion rate per habit:
=COUNTIF(B2:AF2, TRUE) / COUNTA(B2:AF2)
Format the cell as a percentage. You’ll see exactly how consistent you’ve been each month.
Top Article
productivity
AI Writing Assistants — IRL
My actual daily workflow I use Claude for almost every post I write on this site. Not to write the posts — to work …