Google Sheets Bullet Journal Formulas

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

REPT MIN MAX

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

REPT LEN CHAR

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

CHOOSE

Bullet list char

Put list text in B1. Adds a bullet prefix.

=CHAR(8226)&" "&B1

• Item

CHAR

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

CHAR REGEXREPLACE

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

CHAR REGEXREPLACE

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

CHAR REGEXREPLACE

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

CHAR REGEXREPLACE

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

CHAR REGEXREPLACE

Future log arrow

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

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

→ Plan trip →

CHAR

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 ··· ────────────────

REPT LEN CHAR

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

REPT MIN MAX

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

REPT MIN MAX

Gratitude line

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

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

♥ grateful: Morning coffee

CHAR

Migration arrow

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

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

← migrated: Call dentist

CHAR

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

REPT LEN MAX

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

REPT LEN CHAR

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

REPT CHAR MIN

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

CHOOSE

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... │ ╰──────────╯

REPT LEN CHAR

Year-at-a-glance progress

Put months completed 0-12 in A1. Blocks fill your yearly bujo overview.

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

██████░░░░░░ 6/12 mo

REPT MIN MAX

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