All Progress Bars Ratings Scenes Status Timers Pickers Layout Counters Writing Star Wars Lord of the Rings Gamers Kawaii Cozy Bullet Journal D&D Vaporwave Arts & Crafts Fantasy Sports Gym Money Habits Sales School Pokémon Holidays

Word-count bars, chapter progress, and NaNoWriMo pace trackers.

NaNoWriMo 50K word bar

Put word count in A1. Tracks progress toward a fixed 50,000-word goal.

=TEXT(A1,"#,##0")&"/50,000 "&REPT("█",MIN(10,MAX(0,ROUND(A1/50000*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/50000*10,0)))))

24,891/50,000 █████░░░░

TEXT REPT ROUND

Word count progress bar

Put word count in A1 and goal in B1 (e.g. 50000). Ten blocks fill as you write.

=TEXT(A1,"#,##0")&"/"&TEXT(B1,"#,##0")&" "&REPT("█",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))

24,891/50,000 █████░░░░

TEXT REPT ROUND

Chapter progress bar

Put current chapter in A1 and total chapters in B1 (e.g. 20). Shows Ch X/Y with book icons.

="Ch "&A1&"/"&B1&" "&REPT("📖",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("📕",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))

Ch 3/20 📖📖📕📕📕📕📕📕📕📕

REPT ROUND MIN MAX

Writing streak flame

Put streak days in A1 and goal in B1. Flames track consecutive writing days.

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

🔥🔥🔥🔥🔥·· 5 days

REPT MIN MAX

Writing pace and progress

Put word count in A1, goal in B1, total days in C1, and current day in D1. Shows percent done and pace needed.

="Progress: "&TEXT(A1/B1,"0%")&CHAR(10)&"Pace: "&TEXT(MAX(0,ROUND((B1-A1)/MAX(1,C1-D1),0)),"#,##0")&" words/day"

Progress: 50% Pace: 1,667 words/day

TEXT CHAR ROUND MAX

Word count display

Put word count in A1 (0 to 100,000+). Shows the number with comma separators and a words label.

=TEXT(A1,"#,##0")&" words"

24,891 words

TEXT

Word count number only

Put word count in A1. Formats large counts with commas, no label.

=TEXT(A1,"#,##0")

24,891

TEXT

Word count percent

Put word count in A1 and goal in B1. Shows count and percent complete.

=TEXT(A1,"#,##0")&" ("&TEXT(A1/B1,"0%")&")"

24,891 (50%)

TEXT

Book pages word bar

Put word count in A1 and goal in B1. Open books fill in as you hit your target.

=REPT("📖",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("📕",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" "&TEXT(A1,"#,##0")

📖📖📖📖📖📕📕📕📕📕 24,891

REPT TEXT ROUND

Bookshelf word goal

Put word count in A1 and goal in B1. Finished books stack up on the shelf.

="📚 "&TEXT(A1,"#,##0")&"/"&TEXT(B1,"#,##0")&" "&REPT("📗",MIN(5,MAX(0,ROUND(A1/B1*5,0))))&REPT("📕",MAX(0,5-MIN(5,MAX(0,ROUND(A1/B1*5,0)))))

📚 24,891/50,000 📗📗📗📕📕

TEXT REPT ROUND

Quill to finished book

Put word count in A1 and goal in B1. The quill travels from draft to done.

="📕"&REPT("・",MAX(0,10-ROUND(A1/B1*10,0)))&"🖊️"&REPT("・",MAX(0,ROUND(A1/B1*10,0)-1))&"📗"

📕・・・・・🖊️・・・・📗

REPT ROUND TEXT

Daily word target

Put today's word count in A1 and daily goal in B1 (e.g. 1667). Checkmark when you hit target.

=IF(A1>=B1,"✅ "&TEXT(A1,"#,##0")&" words","📝 "&TEXT(A1,"#,##0")&"/"&TEXT(B1,"#,##0"))

📝 1,200/1,667

IF TEXT

Writing sprint bar

Put session word count in A1 and sprint goal in B1 (e.g. 500). Pencils fill the bar.

=REPT("✍️",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("○",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" "&TEXT(A1,"#,##0")

✍️✍️✍️✍️✍️○○○○○ 250

REPT TEXT ROUND

Writing pace needed

Put word count in A1, goal in B1, total days in C1, and current day in D1. Words per day to finish on time.

=TEXT(MAX(0,ROUND((B1-A1)/MAX(1,C1-D1),0)),"#,##0")&" words/day"

1,667 words/day

TEXT ROUND MAX

Writing dashboard

Put word count in A1, goal in B1, total days in C1, and current day in D1. Count, percent, and daily pace in one cell.

="📊 "&TEXT(A1,"#,##0")&"/"&TEXT(B1,"#,##0")&CHAR(10)&"📈 "&TEXT(A1/B1,"0%")&" done"&CHAR(10)&"⏱️ "&TEXT(MAX(0,ROUND((B1-A1)/MAX(1,C1-D1),0)),"#,##0")&"/day"

📊 24,891/50,000 📈 50% done ⏱️ 1,667/day

TEXT CHAR ROUND MAX

Word count pencil tally

Put word count in A1. One pencil per 10,000 words, up to five. Count stays exact.

=TEXT(A1,"#,##0")&IF(A1>=10000," "&REPT("✍️",MIN(5,ROUND(A1/10000,0))),"")

24,891 ✍️✍️

TEXT REPT ROUND

Deadline countdown days

Put manuscript deadline date in A1. Shows days remaining until submit day.

=MAX(0,DATEDIF(TODAY(),A1,"D"))&" days left ✍️"

18 days left ✍️

DATEDIF TODAY MAX

Editing pass scissors bar

Put passes completed in A1 and total passes in B1. Scissors fill the editing bar.

=REPT("✂️",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("○",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" Pass "&A1&"/"&B1

✂️✂️✂️✂️✂️○○○○○ Pass 2/5

REPT ROUND MIN MAX

Submission envelope journey

Put submission step in A1 and total steps in B1. Envelope travels from draft to sent.

="📝"&REPT("·",MAX(0,B1-A1))&"✉️"&REPT("·",MAX(0,A1-1))&"📬"

📝····✉️··📬

REPT MAX

Writer block mood

Put focus level 1-5 in A1. 1 is blocked, 5 is in the flow.

=CHOOSE(A1,"🧱","😶","😐","✍️","🚀")

✍️

CHOOSE

Coffee per 1K words ratio

Put word count in A1 and cups of coffee in B1. Shows cups consumed per 1,000 words.

=IF(A1>0,TEXT(B1/(A1/1000),"0.0")&" cups/1K words ☕","—")

2.0 cups/1K words ☕

IF TEXT

Revision round tracker

Put current revision round in A1 and planned rounds in B1. Arrows mark each draft pass.

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

Round 2/4 🔄🔄○○

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

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons