Spread dividers, dot grids, and bujo mood trackers.

Habit tracker dot grid

Put habits done 0-10 in A1. Filled dots mark completed days.

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

●●●●●○○○○○ habits

Monthly spread divider

Put month name in A1. Bujo-style header with rules above and below. Turn on Wrap text.

=REPT("─",LEN(A1)+4)&CHAR(10)&" "&A1&" "&CHAR(10)&REPT("─",LEN(A1)+4)

────────── March ──────────

Mood tracker color dots

Put mood 1-5 in A1. Color dots match your daily bujo mood key.

=CHOOSE(A1,"🔴 Rough","🟠 Low","🟡 OK","🟢 Good","🔵 Great")

🟢 Good

Bullet list char

Put list text in B1. Adds a bullet prefix.

=CHAR(8226)&" "&B1

• Item

Comma list to bullet points

Put a comma-separated list in B1. Each item gets its own bullet. Turn on Wrap text.

=CHAR(8226)&" "&REGEXREPLACE(B1, ",\s*", CHAR(10)&CHAR(8226)&" ")

• Apple • Banana • Orange

Comma list to checklist

Put a comma-separated list in B1. Empty checkbox before each item. Turn on Wrap text.

=CHAR(9744)&" "&REGEXREPLACE(B1, ",\s*", CHAR(10)&CHAR(9744)&" ")

☐ Apple ☐ Banana ☐ Orange

Comma list to star bullets

Put a comma-separated list in B1. Star before each item. Turn on Wrap text.

=CHAR(9733)&" "&REGEXREPLACE(B1, ",\s*", CHAR(10)&CHAR(9733)&" ")

★ Apple ★ Banana ★ Orange

Comma list to indented bullets

Put a comma-separated list in B1. Indented bullets on each line. Turn on Wrap text.

=" "&CHAR(8226)&" "&REGEXREPLACE(B1, ",\s*", CHAR(10)&" "&CHAR(8226)&" ")

• Apple • Banana • Orange

Semicolon list to bullet points

Put a semicolon-separated list in B1. Bullet on each line. Turn on Wrap text.

=CHAR(8226)&" "&REGEXREPLACE(B1, ";\s*", CHAR(10)&CHAR(8226)&" ")

• Apple • Banana • Orange

Future log arrow

Put future task in A1. Migration arrow points tasks to the future log.

=CHAR(8594)&" "&A1&" "&CHAR(8594)

→ Plan trip →

Daily log date header

Put date text in A1. Daily log title with light rules. Turn on Wrap text.

=REPT("·",3)&" "&A1&" "&REPT("·",3)&CHAR(10)&REPT("─",LEN(A1)+8)

··· Tue Jul 14 ··· ────────────────

Water tracker drops

Put glasses drunk 0-8 in A1. Water drops fill your hydration row.

=REPT("💧",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" glasses"

💧💧💧💧○○○○ glasses

Sleep tracker moons

Put sleep quality 0-5 in A1. Moon phases track restful nights.

=REPT("🌙",MIN(A1,B1))&REPT("☁️",MAX(0,B1-A1))&" sleep"

🌙🌙🌙☁️☁️ sleep

Gratitude line

Put gratitude note in A1. Heart bullet prefixes your bujo gratitude entry.

=CHAR(9829)&" grateful: "&A1

♥ grateful: Morning coffee

Migration arrow

Put task text in A1. Left arrow marks a migrated bujo task.

=CHAR(8592)&" migrated: "&A1

← migrated: Call dentist

Index page numbers

Put topic in A1 and page number in B1. Index row with dot leaders.

=A1&REPT(".",MAX(1,20-LEN(A1)-LEN(B1)))&B1

Habits........12

Washi tape border

Put label in A1. Decorative tape strip frames your bujo section. Turn on Wrap text.

=REPT("▰",LEN(A1)+4)&CHAR(10)&" "&A1&" "&CHAR(10)&REPT("▰",LEN(A1)+4)

▰▰▰▰▰▰▰▰ Goals ▰▰▰▰▰▰▰▰

Weekly spread columns

Put day count 1-7 in A1. Vertical bars sketch a weekly spread. Turn on Wrap text.

=REPT("│"&CHAR(10),MIN(A1,7)-1)&"│"&" week"

│ │ │ week

Goal symbol key

Put goal type 1-4 in A1. Bujo symbols for task, event, note, and priority.

=CHOOSE(A1,"• Task","○ Event","─ Note","! Priority")

• Task

Reflection prompt box

Put reflection text in A1. Light box frames your end-of-day note. Turn on Wrap text.

="╭"&REPT("─",LEN(A1)+2)&"╮"&CHAR(10)&"│ "&A1&" │"&CHAR(10)&"╰"&REPT("─",LEN(A1)+2)&"╯"

╭──────────╮ │ Today... │ ╰──────────╯

Year-at-a-glance progress

Shows year progress from TODAY() as twelve month blocks plus a month count label. Updates daily. No input needed.

=REPT("█",MIN(MONTH(TODAY()),12))&REPT("░",MAX(0,12-MONTH(TODAY())))&" "&MONTH(TODAY())&"/12 mo"

███████░░░░░ 7/12 mo

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.