Google Sheets Habit Tracker Formulas

Streak bars, dot grids, and mood rows for daily tracking.

Don't break chain streak bar

Put streak days in A1 and goal in B1. Green checks mark your unbroken chain.

=REPT("✅",MIN(A1,B1))&REPT("⬜",MAX(0,B1-A1))&" "&A1&" day streak"

✅✅✅✅✅⬜⬜ 5 day streak

REPT MIN MAX

Habit dot grid 7 days

Put habits done 0-7 in A1. Filled dots mark completed days this week.

=REPT("●",MIN(A1,7))&REPT("○",MAX(0,7-A1))&" "&A1&"/7 days"

●●●●●○○ 5/7 days

REPT MIN MAX

Habit dot grid 30 days

Put habits done 0-30 in A1. Thirty dots show your monthly consistency.

=REPT("●",MIN(A1,30))&REPT("○",MAX(0,30-A1))

●●●●●●●●●●●●●●●●●●●●●●○○○○○○○○

REPT MIN MAX

Morning routine checklist

Put morning tasks done in A1 and tasks planned in B1. Sun icons fill the AM row.

=REPT("☀️",MIN(A1,B1))&REPT("⬜",MAX(0,B1-A1))&" AM routine"

☀️☀️☀️☀️⬜⬜ AM routine

REPT MIN MAX

Evening wind-down status

Put wind-down step 1-4 in A1. Moon phases track your nightly shutdown.

=CHOOSE(A1,"🌆 Still working","🍵 Tea time","📵 Screens off","🌙 Asleep")

📵 Screens off

CHOOSE

Daily mood picker

Put mood 1-5 in A1. Happy, neutral, sad, angry, or tired face.

=CHOOSE(A1,"😊","😐","😢","😤","😴")

😐

CHOOSE

Anxiety level meter

Put anxiety 0-10 in A1. Storm clouds thicken as anxiety rises.

=REPT("🌧️",MIN(A1,10))&REPT("☀️",MAX(0,10-A1))&" level "&A1

🌧️🌧️🌧️🌧️☀️☀️☀️☀️☀️☀️ level 4

REPT MIN MAX

Energy battery level

Put energy 0-5 in A1. Battery blocks show how charged you feel.

=REPT("🔋",MIN(A1,5))&REPT("🪫",MAX(0,5-A1))&" energy"

🔋🔋🔋🪫🪫 energy

REPT MIN MAX

Manifestation affirmation tick

Put affirmations read today in A1 and daily goal in B1. Sparkles mark intention work.

=REPT("✨",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" affirmed"

✨✨✨○○ affirmed

REPT MIN MAX

Weekly planning progress

Put planning tasks done in A1 and tasks total in B1. Calendar blocks fill the week plan.

=REPT("📅",MIN(A1,B1))&REPT("⬜",MAX(0,B1-A1))&" planned"

📅📅📅📅⬜⬜ planned

REPT MIN MAX

Goal intention bar

Put intention actions in A1 and weekly target in B1. Target emojis track goal follow-through.

=REPT("🎯",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" "&A1&"/"&B1

🎯🎯🎯🎯○○ 4/6

REPT MIN MAX

Gratitude counter

Put gratitude lines written in A1 and daily goal in B1. Hearts count thankful notes.

=REPT("💛",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" grateful"

💛💛💛○○ grateful

REPT MIN MAX

Meditation minutes bar

Put minutes meditated in A1 and daily goal in B1. Lotus blocks fill as minutes stack.

=REPT("🧘",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("○",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" "&A1&" min"

🧘🧘🧘🧘🧘🧘○○○○ 12 min

REPT ROUND MIN MAX

Screen time shame bar

Put screen hours in A1 and daily limit in B1. Phone blocks shame-scroll past your cap.

=REPT("📱",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" "&A1&"h screen"

📱📱📱📱📱📱📱░░░ 4.2h screen

REPT ROUND MIN MAX

Habit stack flame streak

Put stacked habit days in A1 and goal in B1. Flames track consecutive stack days.

=REPT("🔥",MIN(A1,B1))&REPT("·",MAX(0,B1-A1))&" "&A1&" stack days"

🔥🔥🔥🔥· 4 stack days

REPT MIN MAX

Routine completion stars

Put routine score 0-5 in A1. Stars rate how complete your daily routine feels.

=REPT("⭐",MIN(A1,5))&REPT("☆",MAX(0,5-A1))&" routine"

⭐⭐⭐⭐☆ routine

REPT MIN MAX

Journal entry checkmark

Put 1 if journaled today or 0 if skipped. Quick daily reflection flag.

=IF(A1=1,"✅ Journaled","📝 Not yet")

✅ Journaled

Sleep quality mood

Put sleep quality 1-5 in A1. Moon faces rate last night rest.

=CHOOSE(A1,"😴 Rough","🥱 Tired","😐 OK","😊 Rested","🌙 Great")

😊 Rested

CHOOSE

Focus time pomodoro bar

Put pomodoros done in A1 and daily goal in B1. Tomato blocks track deep work sessions.

=REPT("🍅",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" "&A1&" pomos"

🍅🍅🍅🍅○○ 4 pomos

REPT MIN MAX

Self-care checklist

Put self-care acts done in A1 and acts planned in B1. Spa icons fill the care row.

=REPT("🛁",MIN(A1,B1))&REPT("⬜",MAX(0,B1-A1))&" self-care"

🛁🛁🛁⬜⬜ self-care

REPT MIN MAX

Intentions vs actions bar

Put actions taken in A1 and intentions set in B1. Checks show follow-through gap.

=REPT("✅",MIN(A1,B1))&REPT("💭",MAX(0,B1-A1))&" "&A1&"/"&B1&" done"

✅✅✅💭💭 3/5 done

REPT MIN MAX

Habit journey to goal

Put progress 0-10 in A1. Seed trail grows from sprout to full bloom.

=REPT("🌱",MIN(A1,B1))&REPT("·",MAX(0,B1-A1))&REPT("🌻",IF(A1>=B1,1,0))

🌱🌱🌱🌱🌱·····

REPT MIN MAX IF

Related formula guides

Go deeper with Better Sheets

Members get full courses on CHAR, REPT, and dashboard design, plus hundreds of Google Sheets tutorials. Copy-paste formulas here stay free.

See membership options