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

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

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))

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

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

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

Daily mood picker

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

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

😐

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

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

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

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

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

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

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

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

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

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

Journal entry checkmark

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

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

✅ Journaled

IF

Sleep quality mood

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

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

😊 Rested

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

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

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

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))

🌱🌱🌱🌱🌱·····

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.

Unlock playground
Ads keep the free stuff free. Members browse ad-free — log in or see pricing.
Big Year 2027 calendar: the whole year on one Google Sheet

Free 2027 calendar.Plan all of 2027 on one Google Sheet, free.

Copy it to your Google Drive.

Free. No password, no card. The sheet link shows up right here.