Google Sheets Character Playground

Progress bars, star ratings, emoji scenes, and more.

Block progress bar

Put a score 0-10 in A1. Filled blocks show progress.

=REPT("█",A1)&REPT("░",10-A1)

████████░░

REPT

Star rating (5 stars)

Put rating 0-5 in A1.

=REPT("★",A1)&REPT("☆",5-A1)

★★★☆☆

REPT

3 of 5 with White Star

Put rating 0-5 in A1. Filled stars use CHAR(9734).

=REPT(CHAR(9734),A1)&REPT(CHAR(9885),5-A1)

☆☆☆⚝⚝

REPT CHAR

Star rating with Outlined White Star

Put rating 0-5 in A1. Uses outlined white star glyphs.

=REPT(CHAR(9885),A1)&REPT(CHAR(9734),5-A1)

⚝⚝⚝☆☆

REPT CHAR

3 of 5 with Black Four Pointed Star

Put rating 0-5 in A1. Uses four-pointed star glyphs.

=REPT(CHAR(10022),A1)&REPT(CHAR(10023),5-A1)

✦✦✦✧✧

REPT CHAR

Star rating with White Four Pointed Star

Put rating 0-5 in A1. Uses white four-pointed stars.

=REPT(CHAR(10023),A1)&REPT(CHAR(10022),5-A1)

✧✧✧✦✦

REPT CHAR

Star rating with Stress Outlined White Star

Put rating 0-5 in A1. Uses stress-outlined star glyphs.

=REPT(CHAR(10025),A1)&REPT(CHAR(9885),5-A1)

✩✩✩⚝⚝

REPT CHAR

3 of 5 with Circled White Star

Put rating 0-5 in A1. Uses circled white star glyphs.

=REPT(CHAR(10026),A1)&REPT(CHAR(10023),5-A1)

✪✪✪✧✧

REPT CHAR

Star rating with Open Centre Black Star

Put rating 0-5 in A1. Uses open-centre black stars.

=REPT(CHAR(10027),A1)&REPT(CHAR(10028),5-A1)

✫✫✫✬✬

REPT CHAR

3 of 5 with Black Centre White Star

Put rating 0-5 in A1. Uses black-centre white stars.

=REPT(CHAR(10028),A1)&REPT(CHAR(10027),5-A1)

✬✬✬✫✫

REPT CHAR

Star rating with Outlined Black Star

Put rating 0-5 in A1. Uses outlined black star glyphs.

=REPT(CHAR(10029),A1)&REPT(CHAR(9885),5-A1)

✭✭✭⚝⚝

REPT CHAR

3 of 5 with Heavy Outlined Black Star

Put rating 0-5 in A1. Uses heavy outlined black stars.

=REPT(CHAR(10030),A1)&REPT(CHAR(10025),5-A1)

✮✮✮✩✩

REPT CHAR

Star rating with Pinwheel Star

Put rating 0-5 in A1. Uses pinwheel star glyphs.

=REPT(CHAR(10031),A1)&REPT(CHAR(10037),5-A1)

✯✯✯✵✵

REPT CHAR

3 of 5 with Shadowed White Star

Put rating 0-5 in A1. Uses shadowed white star glyphs.

=REPT(CHAR(10032),A1)&REPT(CHAR(9734),5-A1)

✰✰✰☆☆

REPT CHAR

Star rating with Eight Pointed Black Star

Put rating 0-5 in A1. Uses eight-pointed black stars.

=REPT(CHAR(10036),A1)&REPT(CHAR(10037),5-A1)

✴✴✴✵✵

REPT CHAR

3 of 5 with Eight Pointed Pinwheel Star

Put rating 0-5 in A1. Uses eight-pointed pinwheel stars.

=REPT(CHAR(10037),A1)&REPT(CHAR(10036),5-A1)

✵✵✵✴✴

REPT CHAR

Star rating with Six Pointed Black Star

Put rating 0-5 in A1. Uses six-pointed black stars.

=REPT(CHAR(10038),A1)&REPT(CHAR(10039),5-A1)

✶✶✶✷✷

REPT CHAR

3 of 5 with Eight Pointed Rectilinear Black Star

Put rating 0-5 in A1. Uses rectilinear eight-pointed stars.

=REPT(CHAR(10039),A1)&REPT(CHAR(10040),5-A1)

✷✷✷✸✸

REPT CHAR

Star rating with Heavy Eight Pointed Rectilinear Black Star

Put rating 0-5 in A1. Uses heavy rectilinear stars.

=REPT(CHAR(10040),A1)&REPT(CHAR(10039),5-A1)

✸✸✸✷✷

REPT CHAR

3 of 5 with Twelve Pointed Black Star

Put rating 0-5 in A1. Uses twelve-pointed black stars.

=REPT(CHAR(10041),A1)&REPT(CHAR(9734),5-A1)

✹✹✹☆☆

REPT CHAR

Star rating with Circled Open Centre Eight Pointed Star

Put rating 0-5 in A1. Uses circled open-centre stars.

=REPT(CHAR(10050),A1)&REPT(CHAR(10036),5-A1)

❂❂❂✴✴

REPT CHAR

3 of 5 with White Medium Star

Put rating 0-5 in A1. Uses the medium white star emoji.

=REPT(CHAR(11088),A1)&REPT(CHAR(9734),5-A1)

⭐⭐⭐☆☆

REPT CHAR

Star rating with Glowing Star

Put rating 0-5 in A1. Filled stars use UNICHAR(127775).

=REPT(UNICHAR(127775),A1)&REPT(CHAR(11088),5-A1)

🌟🌟🌟⭐⭐

REPT CHAR UNICHAR

Light block progress

Put a score 0-10 in A1. Lighter shade blocks.

=REPT("▓",A1)&REPT("░",10-A1)

▓▓▓▓▓▓▓▓░░

REPT

Car trip to mountain

Put trip progress 0-10 in A1. Car moves toward the mountain.

="🏔️"&REPT("・",MAX(0,10-A1))&"🚗"&REPT("・",MAX(0,A1-2))

🏔️・・・・・・🚗・・

REPT MAX

Take Ring to Mordor

Put journey progress 0-10 in A1. Ring travels from mountain to home.

=🏔️&REPT("・",MAX(0,10-A1))&"💍"&REPT("・",MAX(0,A1-2))&"🏠"

🏔️・・・・・💍・・・🏠

REPT MAX

Car trip to McDonald's

Put trip progress 0-10 in A1. Car drives toward the fries.

="🍟"&REPT("・",MAX(0,10-A1))&"🚗"&REPT("・",MAX(0,A1-2))

🍟・・・・・・🚗・・

REPT MAX

Burger run by car

Put trip progress 0-10 in A1. Car drives toward a hamburger.

="🍔"&REPT("・",MAX(0,10-A1))&"🚗"&REPT("・",MAX(0,A1-2))

🍔・・・・・・🚗・・

REPT MAX

Soda run to drink break

Put break progress 0-10 in A1. Soda moves toward a drink break.

="☕"&REPT("・",MAX(0,10-A1))&"🥤"&REPT("・",MAX(0,A1-2))

☕・・・・・・🥤・・

REPT MAX

Snack run to snack break

Put break progress 0-10 in A1. Snack moves toward popcorn.

="🍿"&REPT("・",MAX(0,10-A1))&"🍪"&REPT("・",MAX(0,A1-2))

🍿・・・・・・🍪・・

REPT MAX

Traffic light status

Put red, yellow, or green in A1.

=IF(A1="red","🔴",IF(A1="yellow","🟡","🟢"))

🟢

IF

Yes / No status lights

Put yes or no in A1. Anything else shows yellow.

=IF(LOWER(A1)="yes","🟢",IF(LOWER(A1)="no","🔴","🟡"))

🟢

IF LOWER

Approved / Not Approved thumbs

Put approved or not approved in A1. Anything else shows shrug.

=IF(LOWER(A1)="approved","👍",IF(LOWER(A1)="not approved","👎","🤷"))

👍

IF LOWER

Pass / Fail status lights

Put pass or fail in A1.

=IF(LOWER(A1)="pass","🟢",IF(LOWER(A1)="fail","🔴","🟡"))

🟢

IF LOWER

True / False status lights

Put true or false in A1.

=IF(LOWER(A1)="true","🟢",IF(LOWER(A1)="false","🔴","🟡"))

🟢

IF LOWER

On / Off status lights

Put on or off in A1.

=IF(LOWER(A1)="on","🟢",IF(LOWER(A1)="off","🔴","🟡"))

🟢

IF LOWER

Go / Stop status lights

Put go or stop in A1.

=IF(LOWER(A1)="go","🟢",IF(LOWER(A1)="stop","🔴","🟡"))

🟢

IF LOWER

Active / Inactive status lights

Put active or inactive in A1.

=IF(LOWER(A1)="active","🟢",IF(LOWER(A1)="inactive","🔴","🟡"))

🟢

IF LOWER

Done / Pending status lights

Put done or pending in A1. Other values show red.

=IF(LOWER(A1)="done","🟢",IF(LOWER(A1)="pending","🟡","🔴"))

🟢

IF LOWER

Paid / Unpaid status lights

Put paid or unpaid in A1.

=IF(LOWER(A1)="paid","🟢",IF(LOWER(A1)="unpaid","🔴","🟡"))

🟢

IF LOWER

In stock / Out of stock lights

Put in stock or out of stock in A1.

=IF(LOWER(A1)="in stock","🟢",IF(LOWER(A1)="out of stock","🔴","🟡"))

🟢

IF LOWER

Complete / Incomplete status lights

Put complete or incomplete in A1.

=IF(LOWER(A1)="complete","🟢",IF(LOWER(A1)="incomplete","🔴","🟡"))

🟢

IF LOWER

Open / Closed status lights

Put open or closed in A1.

=IF(LOWER(A1)="open","🟢",IF(LOWER(A1)="closed","🔴","🟡"))

🟢

IF LOWER

Yes / No thumbs

Put yes or no in A1. Anything else shows shrug.

=IF(LOWER(A1)="yes","👍",IF(LOWER(A1)="no","👎","🤷"))

👍

IF LOWER

Pass / Fail celebration

Put pass or fail in A1. Anything else shows thinking face.

=IF(LOWER(A1)="pass","🎉",IF(LOWER(A1)="fail","😬","🤔"))

🎉

IF LOWER

Go / Stop road signs

Put go or stop in A1. Anything else shows pause.

=IF(LOWER(A1)="go","🏁",IF(LOWER(A1)="stop","🛑","⏸️"))

🏁

IF LOWER

Active / Inactive energy

Put active or inactive in A1. Anything else shows sleeping.

=IF(LOWER(A1)="active","⚡",IF(LOWER(A1)="inactive","💤","😴"))

⚡

IF LOWER

Done / Pending clocks

Put done or pending in A1. Anything else shows hourglass.

=IF(LOWER(A1)="done","✅",IF(LOWER(A1)="pending","⏳","⌛"))

✅

IF LOWER

Paid / Unpaid money

Put paid or unpaid in A1. Anything else shows question.

=IF(LOWER(A1)="paid","💰",IF(LOWER(A1)="unpaid","💸","❓"))

💰

IF LOWER

In stock / Out of stock boxes

Put in stock or out of stock in A1. Anything else shows shrug.

=IF(LOWER(A1)="in stock","📦",IF(LOWER(A1)="out of stock","📭","🤷"))

📦

IF LOWER

Complete / Incomplete puzzle

Put complete or incomplete in A1. Anything else shows magnifier.

=IF(LOWER(A1)="complete","🧩",IF(LOWER(A1)="incomplete","🚧","🔍"))

🧩

IF LOWER

Open / Closed locks

Put open or closed in A1. Anything else shows key.

=IF(LOWER(A1)="open","🔓",IF(LOWER(A1)="closed","🔒","🔑"))

🔓

IF LOWER

True / False marks

Put true or false in A1. Anything else shows question mark.

=IF(LOWER(A1)="true","✅",IF(LOWER(A1)="false","❌","❔"))

✅

IF LOWER

On / Off power

Put on or off in A1. Anything else shows unplugged.

=IF(LOWER(A1)="on","💡",IF(LOWER(A1)="off","🌙","🔌"))

💡

IF LOWER

Win / Lose trophies

Put win or lose in A1. Anything else shows handshake.

=IF(LOWER(A1)="win","🏆",IF(LOWER(A1)="lose","😢","🤝"))

🏆

IF LOWER

Accept / Decline hands

Put accept or decline in A1. Anything else shows shrug.

=IF(LOWER(A1)="accept","🙌",IF(LOWER(A1)="decline","🙅","🤷"))

🙌

IF LOWER

Safe / Danger shields

Put safe or danger in A1. Anything else shows skull.

=IF(LOWER(A1)="safe","🛡️",IF(LOWER(A1)="danger","⚠️","☠️"))

🛡️

IF LOWER

Online / Offline signal

Put online or offline in A1. Anything else shows sync.

=IF(LOWER(A1)="online","📶",IF(LOWER(A1)="offline","📵","🔄"))

📶

IF LOWER

Like / Dislike hearts

Put like or dislike in A1. Anything else shows neutral face.

=IF(LOWER(A1)="like","❤️",IF(LOWER(A1)="dislike","💔","😐"))

❤️

IF LOWER

Ship / Hold delivery

Put ship or hold in A1. Anything else shows magnifier.

=IF(LOWER(A1)="ship","🚀",IF(LOWER(A1)="hold","⏸️","🔍"))

🚀

IF LOWER

Success / Error bursts

Put success or error in A1. Anything else shows warning.

=IF(LOWER(A1)="success","🎊",IF(LOWER(A1)="error","💥","⚠️"))

🎊

IF LOWER

Healthy / Sick wellness

Put healthy or sick in A1. Anything else shows sneeze.

=IF(LOWER(A1)="healthy","💪",IF(LOWER(A1)="sick","🤒","🤧"))

💪

IF LOWER

Up / Down votes

Put up or down in A1. Anything else shows sideways arrow.

=IF(LOWER(A1)="up","⬆️",IF(LOWER(A1)="down","⬇️","➡️"))

⬆️

IF LOWER

Ready / Not ready checklist

Put ready or not ready in A1. Anything else shows clipboard.

=IF(LOWER(A1)="ready","✅",IF(LOWER(A1)="not ready","📋","📝"))

✅

IF LOWER

Available / Busy calendar

Put available or busy in A1. Anything else shows calendar.

=IF(LOWER(A1)="available","✨",IF(LOWER(A1)="busy","🔥","📅"))

✨

IF LOWER

Yes / No checkmarks

Put Yes or No in A1.

=IF(A1="Yes",CHAR(10004)&" Yes","✗ No")

✔ Yes

IF CHAR

Yes / No with light check mark

Put Yes or No in A1.

=IF(A1="Yes",CHAR(10003)&" Yes",CHAR(10007)&" No")

✓ Yes

IF CHAR

Yes / No with heavy ballot X

Put Yes or No in A1.

=IF(A1="Yes",CHAR(10004)&" Yes",CHAR(10008)&" No")

✔ Yes

IF CHAR

Yes / No with multiplication X

Put Yes or No in A1. No uses a multiplication X.

=IF(A1="Yes",CHAR(10003)&" Yes",CHAR(10006)&" No")

✓ Yes

IF CHAR

Yes / No ballot boxes

Checked box for Yes, empty box for No.

=IF(A1="Yes",CHAR(9745)&" Yes",CHAR(9744)&" No")

☑ Yes

IF CHAR

Yes / No ballot box and X box

Checked box for Yes, X box for No.

=IF(A1="Yes",CHAR(9745)&" Yes",CHAR(9746)&" No")

☑ Yes

IF CHAR

Yes / No checkbox only

Put Yes or No in A1. Shows only the box glyph.

=IF(A1="Yes",CHAR(9745),CHAR(9744))

☑

IF CHAR

TRUE / FALSE checkbox

Put TRUE or FALSE in A1.

=IF(A1=TRUE,CHAR(9745),CHAR(9744))

☑

IF CHAR

Yes / No emoji checks

Put Yes or No in A1. Uses emoji check and X.

=IF(A1="Yes","✅ Yes","❌ No")

✅ Yes

IF

Yes / No check glyphs only

Put Yes or No in A1. No text label.

=IF(A1="Yes",CHAR(10004),CHAR(10007))

✔

IF CHAR

Yes / No case-insensitive checks

Put yes or no in A1. Any casing works.

=IF(LOWER(A1)="yes",CHAR(10004)&" Yes",CHAR(10007)&" No")

✔ Yes

IF LOWER CHAR

Done / Todo checkmarks

Put Done or Todo in A1.

=IF(LOWER(A1)="done",CHAR(10004)&" Done",CHAR(10007)&" Todo")

✔ Done

IF LOWER CHAR

Approved / Rejected checkmarks

Put Approved or Rejected in A1.

=IF(LOWER(A1)="approved",CHAR(10004)&" Approved",CHAR(10008)&" Rejected")

✔ Approved

IF LOWER CHAR

Pass / Fail checkmarks

Put Pass or Fail in A1.

=IF(LOWER(A1)="pass",CHAR(10003)&" Pass",CHAR(10007)&" Fail")

✓ Pass

IF LOWER CHAR

Complete / Incomplete checkmarks

Put Complete or Incomplete in A1.

=IF(LOWER(A1)="complete",CHAR(10004)&" Complete",CHAR(9744)&" Incomplete")

✔ Complete

IF LOWER CHAR

Checked / Unchecked with labels

Put Checked or Unchecked in A1.

=IF(LOWER(A1)="checked",CHAR(9745)&" Checked",CHAR(9744)&" Unchecked")

☑ Checked

IF LOWER CHAR

Heavy check or empty for Yes

Put Yes in A1 for a checkmark. Anything else stays blank.

=IF(A1="Yes",CHAR(10004),"")

✔

IF CHAR

Trend arrows

Put a number in A1. Positive shows up, negative down, zero flat.

=IF(A1>0,"▲ "&A1,IF(A1<0,"▼ "&A1,"→ 0"))

▲ 12

IF

Braille micro-bar

Put a score 0-5 in A1. Tiny braille progress bar.

=REPT("⠿",A1)&REPT("⠀",5-A1)

⠿⠿⠿⠀⠀

REPT

Battery level

Put a percentage 0-100 in A1. Five blocks = 100%.

=REPT("█",MIN(5,MAX(0,ROUND(A1*5/100,0))))&REPT("░",5-MIN(5,MAX(0,ROUND(A1*5/100,0))))&" "&A1&"%"

███░░ 60%

REPT ROUND MIN MAX

Heart health bar

Put HP 0-5 in A1. Filled hearts show remaining health.

=REPT("♥",A1)&REPT("♡",5-A1)

♥♥♥♡♡

REPT

Sound level meter

Put volume level 0-8 in A1.

=LEFT("▁▂▃▄▅▆▇█",MIN(A1,8))

▁▂▃▄▅

LEFT MIN

Loading dots

Animates with NOW(). No input needed; recalculates on refresh.

=REPT("●",MOD(NOW()*86400,4))&REPT("○",4-MOD(NOW()*86400,4))

●●○○

REPT MOD NOW

12-hour clock dots

Filled dots show the current hour on a 12-hour clock. Empty dots fill the rest. Updates whenever NOW() changes.

=REPT("●",HOUR(NOW()))&REPT("○",12-HOUR(NOW()))

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

REPT NOW HOUR

24-hour clock dots

Filled dots show the current hour on a 24-hour clock. Empty dots fill the rest. Updates whenever NOW() changes.

=REPT("●",HOUR(NOW()))&REPT("○",24-HOUR(NOW()))

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

REPT NOW HOUR

Hour hand arrow

Arrow points like a clock hour hand. Twelve directions from NOW(). Updates whenever the sheet recalculates.

=CHOOSE(MOD(HOUR(NOW()),12)+1,"↑","↗","↗","→","↘","↘","↓","↙","↙","←","↖","↖")

↗

CHOOSE HOUR NOW

Minute hand arrow

Arrow sweeps like a minute hand. One tick every five minutes from MINUTE(NOW()).

=CHOOSE(MOD(QUOTIENT(MINUTE(NOW()),5),12)+1,"↑","↗","↗","→","↘","↘","↓","↙","↙","←","↖","↖")

→

CHOOSE MINUTE NOW

Second hand spinner

Arrow spins through eight compass directions each second. Driven by NOW().

=CHOOSE(MOD(NOW()*86400,8)+1,"↑","↗","→","↘","↓","↙","←","↖")

↘

CHOOSE MOD NOW SECOND

Clock hands as arrows

Hour and minute hands as arrows around a center dot. Both update from NOW().

=CHOOSE(MOD(HOUR(NOW()),12)+1,"↑","↗","↗","→","↘","↘","↓","↙","↙","←","↖","↖")&"◎"&CHOOSE(MOD(QUOTIENT(MINUTE(NOW()),5),12)+1,"↑","↗","↗","→","↘","↘","↓","↙","↙","←","↖","↖")

↗◎→

CHOOSE HOUR MINUTE NOW

Clock face emoji

Shows the matching clock-face emoji for the current hour. Updates from HOUR(NOW()).

=CHOOSE(IF(MOD(HOUR(NOW()),12)=0,12,MOD(HOUR(NOW()),12)),"🕐","🕑","🕒","🕓","🕔","🕕","🕖","🕗","🕘","🕙","🕚","🕛")

🕗

CHOOSE HOUR NOW

Live time display

Shows the current time as text. No input needed; updates whenever NOW() changes.

=TEXT(NOW(),"h:mm AM/PM")

8:00 AM

TEXT NOW

Spinning refresh arrow

Arrow rotates ↑ → ↓ ← with NOW(). Good for a live refresh indicator.

=CHOOSE(MOD(NOW()*86400,4)+1,"↑","→","↓","←")

→

CHOOSE MOD NOW

Counterclockwise spinning arrow

Arrow spins the other way through eight directions. Driven by NOW().

=CHOOSE(MOD(NOW()*86400,8)+1,"↑","↖","←","↙","↓","↘","→","↗")

↙

CHOOSE MOD NOW

Second hand radar sweep

Arrow marks the current second on a 60-dot dial. Sweeps with SECOND(NOW()).

=REPT("·",SECOND(NOW()))&"↑"&REPT("·",59-SECOND(NOW()))

······························↑·····························

REPT SECOND NOW

Hour position on dial

One arrow marks the current hour on a 12-tick dial. Empty ticks fill the rest.

=REPT("·",MOD(HOUR(NOW()),12))&"↑"&REPT("·",11-MOD(HOUR(NOW()),12))

·······↑····

REPT HOUR NOW

Minute progress blocks

Twelve blocks show minutes elapsed this hour. One block per five minutes from NOW().

=REPT("█",QUOTIENT(MINUTE(NOW()),5))&REPT("░",12-QUOTIENT(MINUTE(NOW()),5))

██████░░░░░░

REPT MINUTE NOW

Live hourglass flip

Hourglass flips every second with NOW(). No input needed.

=IF(MOD(NOW()*86400,2)=0,CHAR(9203),CHAR(8987))

⏳

IF MOD NOW CHAR

Second countdown pulse

Filled dots count down within each 10-second window. Animates with NOW().

=REPT("●",MOD(60-SECOND(NOW()),10)+1)&REPT("○",10-MOD(60-SECOND(NOW()),10)-1)

●●●●●○○○○○

REPT MOD SECOND NOW

AM or PM indicator

Shows sun for morning and moon for evening based on the current hour.

=IF(HOUR(NOW())<12,"☀️ AM","🌙 PM")

☀️ AM

IF HOUR NOW

Weekday name from NOW

Shows today as a weekday name. Updates whenever the sheet recalculates.

=TEXT(NOW(),"dddd")

Friday

TEXT NOW

Medal podium

Put rank 1, 2, or 3 in A1 for a medal. Other ranks show the number.

=IF(A1=1,"🥇",IF(A1=2,"🥈",IF(A1=3,"🥉"," "&A1)))

🥇

IF

Dice face

Put 1-6 in A1 for a dice face.

=CHOOSE(A1,"⚀","⚁","⚂","⚃","⚄","⚅")

⚂

CHOOSE

Dice face by name

Put one, two, three, four, five, or six in A1 for a dice face.

=SWITCH(LOWER(A1),"one","⚀","two","⚁","three","⚂","four","⚃","five","⚄","six","⚅")

⚂

SWITCH LOWER

Weather row

Put temperature in A1. Hot is sunny, cold is snowy.

=IF(A1>80,"☀️",IF(A1>50,"⛅",IF(A1>20,"🌧️","❄️")))

⛅

IF

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 line breaks

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

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

Apple Banana Orange

REGEXREPLACE CHAR

Comma list to numbered lines

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

=TEXTJOIN(CHAR(10),TRUE,SEQUENCE(COUNTA(SPLIT(B1,",")))&". "&TRIM(SPLIT(B1,",")))

1. Apple 2. Banana 3. Orange

TEXTJOIN SEQUENCE SPLIT CHAR

Comma list to dash lines

Put a comma-separated list in B1. Each item starts with a dash. Turn on Wrap text.

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

- Apple - Banana - Orange

REGEXREPLACE CHAR

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 arrow lines

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

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

→ 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

Comma list to double-spaced lines

Put a comma-separated list in B1. Blank line between each item. Turn on Wrap text.

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

Apple Banana Orange

REGEXREPLACE CHAR

Pipe list to line breaks

Put a pipe-separated list in B1. Each segment on its own line. Turn on Wrap text.

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

Apple Banana Orange

REGEXREPLACE CHAR

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

Text with underline

Put text in A1. Line of dashes below the text. Turn on Wrap text.

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

Title ─────

LEN REPT CHAR

Centered text in cell

Put text in A1 and total width in B1. Pads with spaces to center.

=REPT(" ",MAX(0,INT((B1-LEN(A1))/2)))&A1

Hello

REPT LEN

Right-aligned text in cell

Put text in A1 and total width in B1. Pads with spaces on the left.

=REPT(" ",MAX(0,B1-LEN(A1)))&A1

Hi

REPT LEN

Section title with rules

Put section width in A1 and title in B1. Heavy rules above and below.

=REPT("═",A1)&CHAR(10)&B1&CHAR(10)&REPT("═",A1)

════════ Notes ════════

REPT CHAR

Table row with pipes

Put values in A1, B1, and C1. One pipe-separated table row.

="| "&A1&" | "&B1&" | "&C1&" |"

| Name | Qty | Price |

LEN

Table column header line

Put header text in A1. Top border with side stems.

="├"&REPT("─",LEN(A1)+2)&"┤"&CHAR(10)&"│ "&A1&" │"

├─────┤ │ Qty │

LEN REPT CHAR

Grid top border

Put left column width in A1 and right column width in B1. Two-column table top.

="┌"&REPT("─",A1)&"┬"&REPT("─",B1)&"┐"

┌───┬───┐

REPT

Grid middle row

Put left column width in A1 and right column width in B1. Row separator for two columns.

="├"&REPT("─",A1)&"┼"&REPT("─",B1)&"┤"

├───┼───┤

REPT

Left T divider

Put half-width in A1. Horizontal line with a left stem.

=REPT("─",A1)&"├"&REPT("─",A1)

────├────

REPT

Right T divider

Put half-width in A1. Horizontal line with a right stem.

=REPT("─",A1)&"┤"&REPT("─",A1)

────┤────

REPT

L-shaped corner

Put arm length in A1. Bottom-left corner piece for manual tables.

="└"&REPT("─",A1)

└────

REPT

Three-line menu icon

Put bar width in A1. Stacked horizontal bars. Turn on Wrap text.

=REPT("═",A1)&CHAR(10)&REPT("═",A1)&CHAR(10)&REPT("═",A1)

═══ ═══ ═══

REPT CHAR

Bracket label wrap

Put label text in A1. Wraps it in square brackets.

="["&" "&A1&" "&"]"

[ Hello ]

LEN

Curly quote wrap

Put quote text in A1. Wraps it in curly double quotes.

=CHAR(8220)&A1&CHAR(8221)

“Hello”

CHAR

Ellipsis truncate

Put text in A1 and max length in B1. Adds ... when text is too long.

=IF(LEN(A1)>B1,LEFT(A1,B1-3)&"...",A1)

Long sentence...

IF LEN LEFT

Box border cell

Put inner width in A1. Draws a box around empty space.

="┌"&REPT("─",A1)&"┐"&CHAR(10)&"│"&REPT(" ",A1)&"│"&CHAR(10)&"└"&REPT("─",A1)&"┘"

┌────┐ │ │ └────┘

REPT CHAR

Surround by ASCII

Put text in A1. Double-line top and bottom with text between.

=CHAR(9556)&REPT(CHAR(9552),LEN(A1)+2)&CHAR(9559)&CHAR(10)&A1&CHAR(10)&CHAR(9562)&REPT(CHAR(9552),LEN(A1)+2)&CHAR(9565)

╔═══════╗ Hello ╚═══════╝

REPT LEN CHAR

Rounded border cell

Put inner width in A1. Box with rounded corners.

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

╭────╮ │ │ ╰────╯

REPT CHAR

Heavy border cell

Put inner width in A1. Thick box-drawing characters.

="┏"&REPT("━",A1)&"┓"&CHAR(10)&"┃"&REPT(" ",A1)&"┃"&CHAR(10)&"┗"&REPT("━",A1)&"┛"

┏━━━━┓ ┃ ┃ ┗━━━━┛

REPT CHAR

Text inside box

Put text in A1. Light border with side bars on the text row.

="┌"&REPT("─",LEN(A1)+2)&"┐"&CHAR(10)&"│ "&A1&" │"&CHAR(10)&"└"&REPT("─",LEN(A1)+2)&"┘"

┌────┐ │ Hi │ └────┘

LEN REPT CHAR

Text inside double box

Put text in A1. Double-line border with sides on the text row.

="╔"&REPT("═",LEN(A1)+2)&"╗"&CHAR(10)&"║ "&A1&" ║"&CHAR(10)&"╚"&REPT("═",LEN(A1)+2)&"╝"

╔═══════╗ ║ Hello ║ ╚═══════╝

LEN REPT CHAR

Header box

Put label text in A1. Top and side borders with no bottom row.

="┏"&REPT("━",LEN(A1)+2)&"┓"&CHAR(10)&"┃ "&A1&" ┃"

┏━━━━━━━┓ ┃ Title ┃

LEN REPT CHAR

Side border panel

Put width in A1 and height in B1. Open panel with left and right bars only.

=REPT("│"&REPT(" ",A1)&"│"&CHAR(10),B1-1)&"│"&REPT(" ",A1)&"│"

│ │ │ │ │ │

REPT CHAR

Horizontal rule

Put width in A1. Single row of light dashes.

=REPT("─",A1)

────────

REPT

Dashed horizontal rule

Put width in A1. Dotted horizontal line.

=REPT("┄",A1)

┄┄┄┄┄┄┄┄

REPT

Vertical divider

Put height in A1. Stack light vertical bars. Turn on Wrap text.

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

│ │ │ │

REPT CHAR

T-section divider

Put half-width in A1. Horizontal line with a center stem.

=REPT("─",A1)&"┬"&REPT("─",A1)

────┬────

REPT

Cross divider

Put half-width in A1. Horizontal line with a center cross.

=REPT("─",A1)&"┼"&REPT("─",A1)

────┼────

REPT

ASCII billboard

Put message in A1. Framed sign with a centered peg underneath.

="┌"&REPT("─",LEN(A1)+2)&"┐"&CHAR(10)&"│ "&A1&" │"&CHAR(10)&"└"&REPT("─",INT((LEN(A1)+2)/2))&"┴"&REPT("─",LEN(A1)+2-INT((LEN(A1)+2)/2)-1)&"┘"&CHAR(10)&REPT(" ",1+INT((LEN(A1)+2)/2))&"│"&CHAR(10)&REPT(" ",1+INT((LEN(A1)+2)/2))&"│"

┌──────┐ │ SALE │ └───┴──┘ │ │

LEN REPT CHAR

Goal posts

Put label in A1. Upright posts with a crossbar and your word between.

=" │"&REPT(" ",LEN(A1)+4)&"│"&CHAR(10)&" │"&REPT(" ",LEN(A1)+4)&"│"&CHAR(10)&" │ "&A1&REPT(" ",LEN(A1)+4-LEN(A1)-1)&"│"&CHAR(10)&"─┴"&REPT("─",LEN(A1)+4)&"┴─"

│ │ │ │ │ GOAL │ ─┴────────┴─

LEN REPT CHAR

Hanging sign

Put shop name in A1. Two posts above with a sign hanging below.

="│"&REPT(" ",LEN(A1)+14)&"│"&CHAR(10)&"╰"&REPT("─",INT((LEN(A1)+14)/2))&"┬"&REPT("─",LEN(A1)+14-INT((LEN(A1)+14)/2))&"╯"&CHAR(10)&REPT(" ",INT((LEN(A1)+16)/2))&"│"&CHAR(10)&REPT(" ",INT((LEN(A1)+16)/2)-INT((LEN(A1)+6)/2))&"┌"&REPT("─",INT((LEN(A1)+2)/2))&"┴"&REPT("─",LEN(A1)+2-INT((LEN(A1)+2)/2))&"┐"&CHAR(10)&REPT(" ",INT((LEN(A1)+16)/2)-INT((LEN(A1)+6)/2))&"│ "&A1&" │"&CHAR(10)&REPT(" ",INT((LEN(A1)+16)/2)-INT((LEN(A1)+6)/2))&"└"&REPT("─",LEN(A1)+2)&"┘"

│ │ ╰─────────┬─────────╯ │ ┌───┴───┐ │ OPEN │ └──────┘

LEN REPT CHAR

Surround text with skulls

Put text in A1. Skull rows above and below with skulls on each side. Turn on Wrap text.

=REPT("💀",LEN(A1)+2)&CHAR(10)&"💀 "&A1&" 💀"&CHAR(10)&REPT("💀",LEN(A1)+2)

💀💀💀💀💀 💀 hi 💀 💀💀💀💀💀

REPT LEN CHAR

Surround text with warning signs

Put text in A1. Warning rows above and below with signs on each side. Turn on Wrap text.

=REPT("⚠️",LEN(A1)+2)&CHAR(10)&"⚠️ "&A1&" ⚠️"&CHAR(10)&REPT("⚠️",LEN(A1)+2)

⚠️⚠️⚠️⚠️⚠️ ⚠️ hi ⚠️ ⚠️⚠️⚠️⚠️⚠️

REPT LEN CHAR

Surround text with hearts

Put text in A1. Heart rows above and below with hearts on each side. Turn on Wrap text.

=REPT("❤️",LEN(A1)+2)&CHAR(10)&"❤️ "&A1&" ❤️"&CHAR(10)&REPT("❤️",LEN(A1)+2)

❤️❤️❤️❤️❤️ ❤️ hi ❤️ ❤️❤️❤️❤️❤️

REPT LEN CHAR

Surround text with flames

Put text in A1. Flame rows above and below with flames on each side. Turn on Wrap text.

=REPT("🔥",LEN(A1)+2)&CHAR(10)&"🔥 "&A1&" 🔥"&CHAR(10)&REPT("🔥",LEN(A1)+2)

🔥🔥🔥🔥🔥 🔥 hi 🔥 🔥🔥🔥🔥🔥

REPT LEN CHAR

Upside down text with CHAR

Put text in A1. Each letter maps to an upside-down Unicode character with CHAR(), then the string reverses. Rotate the sheet 180° to read it.

=TEXTJOIN("",TRUE,MAP(SEQUENCE(LEN(A1)),LAMBDA(i,SWITCH(MID(A1,LEN(A1)-i+1,1),"a",CHAR(592),"b","q","c",CHAR(596),"d","p","e",CHAR(477),"f",CHAR(607),"g",CHAR(387),"h",CHAR(613),"i",CHAR(7425),"j",CHAR(638),"k",CHAR(670),"l","l","m",CHAR(623),"n","u","o","o","p","d","q","b","r",CHAR(633),"s","s","t",CHAR(647),"u","n","v",CHAR(652),"w",CHAR(653),"x","x","y",CHAR(654),"z","z","A",CHAR(8704),"C",CHAR(390),"E",CHAR(398),"F",CHAR(8498),"L",CHAR(741),"M","W","P","d","T",CHAR(8868),"U",CHAR(8745),"V",CHAR(923),"Y",CHAR(8516),"0","0","1",CHAR(406),"2",CHAR(8586),"3",CHAR(8587),"5",CHAR(987),"6","9","7",CHAR(12581),"9","6",".",CHAR(729),"!",CHAR(161),"?",CHAR(191),"(",")",")","(",MID(A1,LEN(A1)-i+1,1)))))

ollǝɥ

CHAR MAP TEXTJOIN

Sparkline blocks

Put a score 0-10 in A1. Mini bar chart in one cell.

=REPT("█",A1)&REPT("▁",10-A1)

█████▁▁▁▁▁

REPT

Mood faces

Put mood 1-5 in A1. 1 is sad, 5 is happy.

=CHOOSE(A1,"😢","😕","😐","🙂","😄")

🙂

CHOOSE

Password strength

Put strength 0-5 in A1. Labels Weak, OK, or Strong.

=REPT("█",A1)&REPT("░",5-A1)&" "&IF(A1>=4,"Strong",IF(A1>=2,"OK","Weak"))

███░░ OK

REPT IF

Tree growth stages

Put stage 1-4 in A1. Seedling grows into a tree.

=CHOOSE(MIN(A1,4),"🌱","🌿","🌳","🌲","🌲")

🌳

CHOOSE MIN

Growth completion by percentage

Put completion 0-100 in A1. Grows every 25%.

=CHOOSE(IF(A1>=100,5,IF(A1>75,4,IF(A1>50,3,IF(A1>25,2,1)))),"🌱","🌿","🌳","🌲","🌲")

🌱🌿🌳🌲🌲

IF CHOOSE

Arrow compass

Put direction 1-8 in A1. Clockwise from north.

=CHOOSE(A1,"↑","↗","→","↘","↓","↙","←","↖")

→

CHOOSE

Compass direction arrows

Put a direction in A1: North, South, East, West, or diagonals like North East.

=SWITCH(A1,"North",CHAR(8593),"North East",CHAR(8599),"East",CHAR(8594),"South East",CHAR(8600),"South",CHAR(8595),"South West",CHAR(8601),"West",CHAR(8592),"North West",CHAR(8598))

North → ↑

SWITCH CHAR

Snail race to finish

Put lap position 0-10 in A1. Snail crawls toward the checkered flag.

=REPT("·",A1)&"🐌"&REPT("·",MAX(0,10-A1))&"🏁"

···🐌······🏁

REPT MAX

Poop races to the toilet

Put checked count 0-10 in A1. Each check pulls 💩 closer to 🚽.

=REPT("·",A1)&"💩"&REPT("·",MAX(0,10-A1))&"🚽"

···💩·······🚽

REPT MAX

Rocket launch pad

Higher A1 adds more flame blocks under the rocket.

=REPT("·",MAX(0,8-A1))&"🚀"&REPT(CHAR(9650),A1)

·····🚀▲▲▲

REPT MAX CHAR

Fire intensity meter

Put intensity 0-5 in A1.

=REPT("🔥",A1)&REPT("○",5-A1)

🔥🔥🔥○○

REPT

Coffee cup counter

Put cups drunk 0-5 in A1.

=REPT("☕",A1)&REPT("○",5-A1)

☕☕☕○○

REPT

Pizza slice tracker

Put slices left in A1.

=REPT("🍕",A1)&" left"

🍕🍕🍕 left

REPT

Ice cream scoops

Put scoop count 0-5 in A1.

=REPT("🍦",A1)&REPT("·",5-A1)

🍦🍦🍦··

REPT

Hearts counter

Put love level 0-5 in A1. Filled red hearts show the score.

=REPT("❤️",A1)&REPT("🤍",5-A1)

❤️❤️❤️🤍🤍

REPT

Mending hearts counter

Put love level 0-5 in A1. Score 1 is broken, 2-3 mending, 4-5 full hearts.

=IF(A1<=0,REPT("🤍",5),IF(A1=1,REPT("💔",1)&REPT("🤍",4),IF(A1<=3,REPT("❤️‍🩹",A1)&REPT("🤍",5-A1),REPT("❤️",A1)&REPT("🤍",5-A1))))

❤️‍🩹❤️‍🩹🤍🤍🤍

REPT IF

Hearts white to red counter

Put love level 0-5 in A1. Each slot turns from white to red as the score rises.

=IF(A1>=1,"❤️","🤍")&IF(A1>=2,"❤️","🤍")&IF(A1>=3,"❤️","🤍")&IF(A1>=4,"❤️","🤍")&IF(A1>=5,"❤️","🤍")

❤️❤️❤️🤍🤍

IF

Rainbow hearts counter

Put love level 0-5 in A1. Each filled heart gets its own color.

=IF(A1>=1,"❤️","🤍")&IF(A1>=2,"🧡","🤍")&IF(A1>=3,"💛","🤍")&IF(A1>=4,"💚","🤍")&IF(A1>=5,"💙","🤍")

❤️🧡💛🤍🤍

IF

Taco Tuesday count

Put taco count in A1.

=REPT("🌮",A1)

🌮🌮🌮

REPT

Taco Rating

Put rating 1-5 in A1.

=REPT("🌮",A1)&" out of 5"

🌮🌮🌮🌮🌮 out of 5

REPT

Sushi plate rating

Put rating 0-5 in A1.

=REPT("🍣",A1)&REPT("○",5-A1)

🍣🍣🍣○○

REPT

Colored book rating

Put rating 0-5 in A1. Closed books fill the row.

=REPT("📕",A1)&REPT("📖",5-A1)

📕📕📕📖📖

REPT

Book stack rating

Put rating 0-5 in A1. Stacks for filled, single books for empty.

=REPT("📚",A1)&REPT("📕",5-A1)

📚📚📚📕📕

REPT

Fire rating

Put rating 0-5 in A1. More fire, hotter the score.

=REPT("🔥",A1)&REPT("○",5-A1)

🔥🔥🔥○○

REPT

Coffee rating

Put rating 0-5 in A1. Cups show how strong the brew is.

=REPT("☕",A1)&REPT("○",5-A1)

☕☕☕○○

REPT

Thumbs up rating

Put rating 0-5 in A1. Thumbs up for every point scored.

=REPT("👍",A1)&REPT("○",5-A1)

👍👍👍○○

REPT

Thumbs up and down rating

Put rating 0-5 in A1. Thumbs up for score, thumbs down for the rest.

=REPT("👍",A1)&REPT("👎",5-A1)

👍👍👍👎👎

REPT

Skull rating

Put rating 0-5 in A1. Skulls mark the danger level.

=REPT("💀",A1)&REPT("○",5-A1)

💀💀💀○○

REPT

Hot dog and donut rating

Put 0 or 1 in A1. Donut for zero, hot dog for one.

=IF(A1=1,"🌭","🍩")

🌭

IF

Green apple go / red apple no

Put yes, no, go, or stop in A1. Green apple for go, red apple for no.

=IF(OR(LOWER(A1)="yes",LOWER(A1)="go"),"🍏",IF(OR(LOWER(A1)="no",LOWER(A1)="stop"),"🍎","🤷"))

🍏

IF LOWER OR

Chess rank badge

Put rank 1-6 in A1: pawn through king.

=CHOOSE(A1,CHAR(9823),CHAR(9822),CHAR(9821),CHAR(9820),CHAR(9819),CHAR(9818))

♛

CHOOSE CHAR

Playing card suit

Put 1-4 in A1 for spade, heart, diamond, or club.

=CHOOSE(A1,CHAR(9824),CHAR(9829),CHAR(9830),CHAR(9827))

♠

CHOOSE CHAR

Gold bar vault

Put gold level 0-5 in A1. Block shading shows fill.

=REPT(CHAR(9619),A1)&REPT(CHAR(9617),5-A1)

▓▓▓░░

REPT CHAR

Wifi signal bars

Put signal strength 1-5 in A1.

=CHOOSE(A1,CHAR(9601),CHAR(9601)&CHAR(9602),CHAR(9604)&CHAR(9605),CHAR(9606)&CHAR(9607),REPT(CHAR(9608),4))

▄▅

REPT CHOOSE CHAR

Pin map journey

Put progress 0-10 in A1. Pin travels toward home.

=REPT("·",A1)&"📍"&REPT("·",MAX(0,10-A1))&"🏠"

···📍····🏠

REPT MAX

Ship sailing home

Put progress 0-8 in A1. Boat sails across wave emojis.

=REPT("🌊",A1)&"⛵"&REPT("🌊",MAX(0,8-A1))

🌊🌊🌊⛵🌊🌊🌊🌊

REPT MAX

Clap-o-meter

Put applause count in A1.

=REPT("👏",A1)

👏👏👏

REPT

Trophy shelf

Put trophies won 0-5 in A1. Empty slots show outline stars.

=REPT("🏆",A1)&REPT(CHAR(9734),5-A1)

🏆🏆☆☆☆

REPT CHAR

Moon phase picker

Put phase 1-8 in A1 for the lunar cycle.

=CHOOSE(A1,"🌑","🌒","🌓","🌔","🌕","🌖","🌗","🌘")

🌓

CHOOSE

Moon phase by name

Put a phase name in A1: new, waxing crescent, first quarter, waxing gibbous, full, waning gibbous, last quarter, or waning crescent.

=SWITCH(LOWER(A1),"new","🌑","waxing crescent","🌒","first quarter","🌓","waxing gibbous","🌔","full","🌕","waning gibbous","🌖","last quarter","🌗","waning crescent","🌘","🌑")

🌕

SWITCH LOWER

Chicken life cycle

Put stage 1-4 in A1. Egg hatches into a hen.

=CHOOSE(A1,"🥚","🐣","🐤","🐔")

🐤

CHOOSE

Butterfly metamorphosis

Put stage 1-4 in A1. Egg, caterpillar, cocoon, butterfly.

=CHOOSE(A1,"🥚","🐛","🛌","🦋")

🦋

CHOOSE

Dragon hatching

Put stage 1-4 in A1. Egg cracks into a full dragon.

=CHOOSE(A1,"🥚","🐣","🐲","🐉")

🐲

CHOOSE

Storm brewing phases

Put intensity 1-5 in A1. Clear sky builds into a thunderstorm.

=CHOOSE(A1,"☀️","🌤️","🌥️","🌧️","⛈️")

🌧️

CHOOSE

Four seasons

Put season 1-4 in A1. Spring, summer, fall, winter.

=CHOOSE(A1,"🌸","☀️","🍂","❄️")

🍂

CHOOSE

Day arc phases

Put hour block 1-6 in A1. Night, sunrise, midday, afternoon, sunset, moon.

=CHOOSE(A1,"🌃","🌅","☀️","🌤️","🌇","🌙")

🌇

CHOOSE

Water cycle phases

Put phase 1-4 in A1. Ocean, evaporation, cloud, rain.

=CHOOSE(A1,"🌊","☀️","☁️","🌧️")

☁️

CHOOSE

Project lifecycle

Put stage 1-5 in A1. Idea, plan, build, ship, celebrate.

=CHOOSE(A1,"💡","📝","🔨","✅","🎉")

🔨

CHOOSE

Treasure hunt story

Put step 1-5 in A1. Map, sail, island, dig, gold.

=CHOOSE(A1,"🗺️","⛵","🏝️","🕳️","💰")

🏝️

CHOOSE

Campfire growth

Put stage 1-4 in A1. Wood, spark, fire, campsite.

=CHOOSE(A1,"🪵","✨","🔥","🏕️")

🔥

CHOOSE

Soup cooking story

Put step 1-4 in A1. Chop veggies, simmer pot, serve bowl, enjoy.

=CHOOSE(A1,"🥕","🍲","🥣","😋")

🍲

CHOOSE

Pizza baking stages

Put stage 1-4 in A1. Dough, toppings, oven, slice.

=CHOOSE(A1,"🫓","🧀","🍕","😋")

🍕

CHOOSE

Snowman building

Put step 1-4 in A1. Snow, body, scarf, finished snowman.

=CHOOSE(A1,"❄️","⛄","🧣","☃️")

⛄

CHOOSE

Book reading progress

Put progress 1-4 in A1. Closed, reading, almost done, finished.

=CHOOSE(A1,"📕","📖","📗","✅")

📖

CHOOSE

Rocket launch story

Put step 1-5 in A1. Prep, fuel, launch, blastoff, orbit.

=CHOOSE(A1,"🔧","⛽","🚀","🔥","🌌")

🚀

CHOOSE

Cat affection levels

Put level 1-4 in A1. Grumpy, curious, happy, loving.

=CHOOSE(A1,"😾","😼","😸","😻")

😸

CHOOSE

Sick to well recovery

Put stage 1-5 in A1. Sniffles, fever, medicine, doctor, healthy.

=CHOOSE(A1,"🤧","🤒","💊","🩺","😊")

💊

CHOOSE

Ocean depth zones

Put depth level 1-5 in A1. Beach, reef, deep sea, shark zone, trench.

=CHOOSE(A1,"🏖️","🐠","🐙","🦈","🌑")

🐙

CHOOSE

Reaction face picker

Put reaction 1-3 in A1. 1 is stern, 2 is shrug, 3 is cool.

=CHOOSE(A1,"ಠ_ಠ","¯\_(ツ)_/¯","(▀̿Ĺ̯▀̿ ̿)")

¯\_(ツ)_/¯

CHOOSE

Reaction face by name

Put stern, shrug, or cool in A1. Anything else shows shrug.

=SWITCH(LOWER(A1),"stern","ಠ_ಠ","shrug","¯\_(ツ)_/¯","cool","(▀̿Ĺ̯▀̿ ̿)","¯\_(ツ)_/¯")

ಠ_ಠ

SWITCH LOWER

Kaomoji outrage picker

Put mood 1-4 in A1. Table flip, rage flip, bear, or hug.

=CHOOSE(A1,"(╯°□°)╯︵ ┻━┻","(ノಠ益ಠ)ノ彡┻━┻","ʕ•ᴥ•ʔ","(づ｡◕‿‿◕｡)づ")

(╯°□°)╯︵ ┻━┻

CHOOSE

Planet picker

Put planet 1-8 in A1. Mercury through Neptune.

=CHOOSE(A1,"☿️","♀️","🌍","♂️","♃","♄","♅","♆")

🌍

CHOOSE

Zodiac sign picker

Put a birthday date in A1. Returns the zodiac sign symbol.

=CHOOSE(LOOKUP(MONTH(A1)*100+DAY(A1),{101,120,219,321,420,521,621,723,823,923,1023,1122,1222},{1,2,3,4,5,6,7,8,9,10,11,12,1}),"♑","♒","♓","♈","♉","♊","♋","♌","♍","♎","♏","♐")

♋

CHOOSE LOOKUP MONTH DAY

Fitness rank badges

Put rank 1-4 in A1. Bronze, silver, gold, champion.

=CHOOSE(A1,"🥉","🥈","🥇","🏆")

🥇

CHOOSE

Umbrella rain test

Put rainfall percent in A1. Over 50 shows wet.

=IF(A1>50,"☔ Wet","☀ Dry")

☔ Wet

IF

Wind gust strength

Put wind level 0-5 in A1.

=REPT("💨",A1)&REPT("·",5-A1)

💨💨💨··

REPT

Snowfall depth

Put snow depth 0-10 in A1.

=REPT("❄",A1)&REPT("·",10-A1)

❄❄❄❄·······

REPT

Thermometer strip

Put temperature in A1. Shows a 10-block strip plus degrees.

=REPT(CHAR(9619),A1)&REPT(CHAR(9617),10-A1)&" "&A1&CHAR(176)

▓▓▓▓▓░░░░░ 72°

REPT CHAR

Hourglass flip

Even numbers show one hourglass, odd numbers the other.

=IF(MOD(A1,2)=0,CHAR(9203),CHAR(8987))

⏳

IF MOD CHAR

Alarm clock urgency

Put alarm count in A1. More clocks, louder wake-up.

=REPT("⏰",A1)&" Wake up!"

⏰⏰ Wake up!

REPT

Alarm hour match

Put target hour 0-23 in A1 (24-hour clock). Rings when the current hour matches.

=IF(HOUR(NOW())=A1,REPT("⏰",3)&" Wake up!","💤 Sleeping")

⏰⏰⏰ Wake up!

IF HOUR NOW REPT

Birthday candle count

Put age or candle count in A1.

=REPT("🕯",A1)&"🎂"

🕯🕯🕯🎂

REPT

Christmas star tree

Put decoration level 0-8 in A1. Stars lead to the tree.

=REPT(CHAR(9733),A1)&"🎄"&REPT("·",MAX(0,8-A1))

★★★🎄·····

REPT MAX CHAR

Halloween pumpkin row

Put pumpkin count in A1. Caps at five.

=REPT("🎃",MIN(A1,5))

🎃🎃🎃

REPT MIN

Easter egg hunt

Put eggs found 0-5 in A1.

=REPT("🥚",A1)&REPT("🌿",5-A1)

🥚🥚🥚🌿🌿

REPT

Football field push

Put yards gained 0-10 in A1. Ball advances downfield.

=REPT(CHAR(9619),A1)&"🏈"&REPT(CHAR(9617),10-A1)

▓▓▓🏈░░░░░░░

REPT CHAR

Basketball shots made

Put shots made 0-5 in A1.

=REPT("🏀",A1)&REPT("○",5-A1)

🏀🏀🏀○○

REPT

Tennis rally counter

Put rally count in A1.

=REPT("🎾",A1)

🎾🎾🎾

REPT

Swimming lap tracker

Put lap count in A1. Swimmer plus wave marks.

=REPT("🏊",1)&REPT("〰",A1)

🏊〰〰〰

REPT

Yoga calm meter

Put calm level in A1. Peace sign at the end.

=REPT("🧘",1)&REPT("·",A1)&REPT("☮",1)

🧘···☮

REPT

Reading page progress

Put pages read 0-5 in A1.

=REPT("📖",A1)&REPT("📕",5-A1)

📖📖📖📕📕

REPT

Email inbox pile

Put unread count in A1.

=REPT("📧",A1)&" unread"

📧📧📧 unread

REPT

Piggy bank savings

Put coin count in A1.

=REPT("🐷",1)&REPT("💰",A1)

🐷💰💰💰

REPT

Light bulb ideas

Put idea count 0-5 in A1.

=REPT("💡",A1)&REPT("○",5-A1)

💡💡💡○○

REPT

Music note volume

Put note count in A1. Quarter and eighth notes.

=REPT(CHAR(9834),A1)&REPT(CHAR(9835),MAX(0,3-A1))

♪♪♪♫

REPT MAX CHAR

Guitar solo intensity

Put solo intensity in A1.

=REPT("🎸",1)&REPT(CHAR(9834),A1)

🎸♪♪♪

REPT CHAR

Karaoke mic level

Put mic level 0-5 in A1. Block meter beside the mic.

=REPT("🎤",1)&REPT(CHAR(9601),A1)&REPT(CHAR(9608),5-A1)

🎤▁▁███

REPT CHAR

Popcorn movie rating

Put rating 0-5 in A1. Popcorn plus star row.

=REPT("🍿",1)&REPT(CHAR(9733),A1)&REPT(CHAR(9734),5-A1)

🍿★★★☆☆

REPT CHAR

Game controller lives

Put lives left 0-3 in A1.

=REPT("🎮",A1)&REPT("✗",3-A1)

🎮🎮🎮

REPT

Puzzle pieces solved

Put pieces placed in A1.

=REPT("🧩",A1)&REPT("□",9-A1)

🧩🧩🧩□□□□□□

REPT

Slot machine cherries

Put match count in A1. Cherries vs lemons.

=REPT("🍒",A1)&REPT("🍋",3-A1)

🍒🍒🍋

REPT

Dragon HP bar

Put hit points 0-10 in A1.

=REPT(CHAR(9829),MIN(A1,5))&REPT(CHAR(9608),MAX(0,A1-5))&REPT(CHAR(9617),10-A1)&" 🐉"

♥♥█░░ 🐉

REPT MIN MAX CHAR

Wizard sparkle level

Put magic level in A1.

=REPT("🧙",1)&REPT("✨",A1)

🧙✨✨✨

REPT

Castle wall defense

Put wall strength 0-10 in A1. Solid blocks build up to the castle.

=REPT(CHAR(9608),A1)&"🏰"&REPT(CHAR(9617),10-A1)

███🏰░░░░░░░

REPT CHAR

Fence perimeter defense

Put fence strength 0-10 in A1. Blocks stack toward the barrier.

=REPT(CHAR(9608),A1)&"🚧"&REPT(CHAR(9617),10-A1)

███🚧░░░░░░░

REPT CHAR

Home fortification

Put fortify progress 0-10 in A1. Wall builds toward home.

=REPT(CHAR(9608),A1)&"🏠"&REPT(CHAR(9617),10-A1)

███🏠░░░░░░░

REPT CHAR

Forest tree line

Put clearance 0-10 in A1. Cleared path reaches the tree line.

=REPT(CHAR(9608),A1)&"🌲"&REPT(CHAR(9617),10-A1)

███🌲░░░░░░░

REPT CHAR

Bank vault barrier

Put security level 0-10 in A1. Dark blocks seal the vault.

=REPT(CHAR(9619),A1)&"🏦"&REPT(CHAR(9617),10-A1)

▓▓▓🏦░░░░░░░

REPT CHAR

Brick wall gate

Put build progress 0-10 in A1. Bricks stack toward the gate.

=REPT("🧱",A1)&"🚪"&REPT(CHAR(9617),10-A1)

🧱🧱🧱🚪░░░░░░░

REPT CHAR

Garden fence gate

Put fence progress 0-10 in A1. Blocks reach the garden gate.

=REPT(CHAR(9608),A1)&"🌷"&REPT(CHAR(9617),10-A1)

███🌷░░░░░░░

REPT CHAR

Camp perimeter wall

Put camp defense 0-10 in A1. Wall closes in on the tent.

=REPT(CHAR(9608),A1)&"⛺"&REPT(CHAR(9617),10-A1)

███⛺░░░░░░░

REPT CHAR

Treasure hoard guard

Put guard level 0-10 in A1. Blocks protect the gold.

=REPT(CHAR(9608),A1)&"💰"&REPT(CHAR(9617),10-A1)

███💰░░░░░░░

REPT CHAR

Soccer goal defense

Put defense rating 0-10 in A1. Back line holds the goal.

=REPT(CHAR(9608),A1)&"🥅"&REPT(CHAR(9617),10-A1)

███🥅░░░░░░░

REPT CHAR

Beehive barrier

Put hive defense 0-10 in A1. Wall shields the honey.

=REPT(CHAR(9608),A1)&"🍯"&REPT(CHAR(9617),10-A1)

███🍯░░░░░░░

REPT CHAR

Harbor dock wall

Put dock progress 0-10 in A1. Pier builds toward the anchor.

=REPT(CHAR(9608),A1)&"⚓"&REPT(CHAR(9617),10-A1)

███⚓░░░░░░░

REPT CHAR

Barn paddock fence

Put fence progress 0-10 in A1. Rails close around the barn.

=REPT(CHAR(9608),A1)&"🐄"&REPT(CHAR(9617),10-A1)

███🐄░░░░░░░

REPT CHAR

Hospital ward barrier

Put safety level 0-10 in A1. Barrier reaches the ward.

=REPT(CHAR(9608),A1)&"🏥"&REPT(CHAR(9617),10-A1)

███🏥░░░░░░░

REPT CHAR

School yard fence

Put fence progress 0-10 in A1. Wall rings the school.

=REPT(CHAR(9608),A1)&"🏫"&REPT(CHAR(9617),10-A1)

███🏫░░░░░░░

REPT CHAR

Space base shield

Put shield strength 0-10 in A1. Blocks protect the rocket.

=REPT(CHAR(9608),A1)&"🚀"&REPT(CHAR(9617),10-A1)

███🚀░░░░░░░

REPT CHAR

Seed to sunflower

Put growth stage 1-5 in A1.

=CHOOSE(A1,"🌰","🌱","🌿","🌻","🌻")

🌻

CHOOSE

Wood to fire to ash

Put burn progress 0-10 in A1. Logs catch fire, then cool to gray ash.

=IF(A1<=3,REPT("🪵",A1)&REPT("░",10-A1),IF(A1<=7,REPT("🪵",3)&REPT("🔥",A1-3)&REPT("░",10-A1),REPT("🪵",3)&REPT("🔥",4)&REPT("⬛",A1-7)&REPT("░",10-A1)))

🪵🪵🪵🔥🔥🔥🔥⬛⬛░

IF REPT

Seedling to flower bloom

Put growth progress 0-10 in A1. Sprouts become plants, then blossoms.

=IF(A1<=3,REPT("🌱",A1)&REPT("░",10-A1),IF(A1<=6,REPT("🌱",3)&REPT("🌿",A1-3)&REPT("░",10-A1),REPT("🌱",3)&REPT("🌿",3)&REPT("🌸",A1-6)&REPT("░",10-A1)))

🌱🌱🌱🌿🌿🌿🌸🌸░░

IF REPT

Cow herd to milk

Put dairy progress 0-10 in A1. Cows fill the bar, then milk takes over.

=IF(A1<=5,REPT("🐄",A1)&REPT("░",10-A1),REPT("🐄",5)&REPT("🥛",A1-5)&REPT("░",10-A1))

🐄🐄🐄🐄🐄🥛🥛🥛░░

IF REPT

Egg to chicken

Put hatch progress 0-10 in A1. Eggs crack, chicks emerge, hens rule the roost.

=IF(A1<=3,REPT("🥚",A1)&REPT("░",10-A1),IF(A1<=6,REPT("🥚",3)&REPT("🐣",A1-3)&REPT("░",10-A1),REPT("🥚",3)&REPT("🐣",3)&REPT("🐔",A1-6)&REPT("░",10-A1)))

🥚🥚🥚🐣🐣🐣🐔🐔░░

IF REPT

Grapes to wine

Put ferment progress 0-10 in A1. Clusters crush down into glasses of wine.

=IF(A1<=5,REPT("🍇",A1)&REPT("░",10-A1),REPT("🍇",5)&REPT("🍷",A1-5)&REPT("░",10-A1))

🍇🍇🍇🍇🍇🍷🍷🍷░░

IF REPT

Dough to bread

Put bake progress 0-10 in A1. Dough rises in the oven, then comes out as loaves.

=IF(A1<=3,REPT("🫓",A1)&REPT("░",10-A1),IF(A1<=6,REPT("🫓",3)&REPT("🔥",A1-3)&REPT("░",10-A1),REPT("🫓",3)&REPT("🔥",3)&REPT("🍞",A1-6)&REPT("░",10-A1)))

🫓🫓🫓🔥🔥🔥🍞🍞░░

IF REPT

Caterpillar to butterfly

Put metamorphosis progress 0-10 in A1. Larva cocoons, then wings unfurl.

=IF(A1<=3,REPT("🐛",A1)&REPT("░",10-A1),IF(A1<=6,REPT("🐛",3)&REPT("🛌",A1-3)&REPT("░",10-A1),REPT("🐛",3)&REPT("🛌",3)&REPT("🦋",A1-6)&REPT("░",10-A1)))

🐛🐛🐛🛌🛌🛌🦋🦋░░

IF REPT

Wheat to toast

Put harvest progress 0-10 in A1. Grain becomes dough, then golden toast.

=IF(A1<=3,REPT("🌾",A1)&REPT("░",10-A1),IF(A1<=6,REPT("🌾",3)&REPT("🫓",A1-3)&REPT("░",10-A1),REPT("🌾",3)&REPT("🫓",3)&REPT("🍞",A1-6)&REPT("░",10-A1)))

🌾🌾🌾🫓🫓🫓🍞🍞░░

IF REPT

Bean to coffee cup

Put brew progress 0-10 in A1. Beans grind down into steaming cups.

=IF(A1<=5,REPT("🫘",A1)&REPT("░",10-A1),REPT("🫘",5)&REPT("☕",A1-5)&REPT("░",10-A1))

🫘🫘🫘🫘🫘☕☕☕░░

IF REPT

Cocoa to chocolate

Put melt progress 0-10 in A1. Pods and beans become chocolate bars.

=IF(A1<=5,REPT("🌰",A1)&REPT("░",10-A1),REPT("🌰",5)&REPT("🍫",A1-5)&REPT("░",10-A1))

🌰🌰🌰🌰🌰🍫🍫🍫░░

IF REPT

Ice cube to puddle

Put melt progress 0-10 in A1. Ice thaws into water.

=IF(A1<=5,REPT("🧊",A1)&REPT("░",10-A1),REPT("🧊",5)&REPT("💧",A1-5)&REPT("░",10-A1))

🧊🧊🧊🧊🧊💧💧💧░░

IF REPT

Snow to snowman

Put build progress 0-10 in A1. Flakes pile up into a finished snowman.

=IF(A1<=6,REPT("❄️",A1)&REPT("░",10-A1),REPT("❄️",6)&REPT("⛄",A1-6)&REPT("░",10-A1))

❄️❄️❄️❄️❄️❄️⛄⛄⛄░

IF REPT

Cloud to rainfall

Put storm progress 0-10 in A1. Clouds darken, then rain pours down.

=IF(A1<=5,REPT("☁️",A1)&REPT("░",10-A1),REPT("☁️",5)&REPT("🌧️",A1-5)&REPT("░",10-A1))

☁️☁️☁️☁️☁️🌧️🌧️🌧️░░

IF REPT

Fish to sushi

Put prep progress 0-10 in A1. Fresh catch becomes plated sushi.

=IF(A1<=5,REPT("🐟",A1)&REPT("░",10-A1),REPT("🐟",5)&REPT("🍣",A1-5)&REPT("░",10-A1))

🐟🐟🐟🐟🐟🍣🍣🍣░░

IF REPT

Potato to fries

Put fry progress 0-10 in A1. Spuds slice up into crispy fries.

=IF(A1<=5,REPT("🥔",A1)&REPT("░",10-A1),REPT("🥔",5)&REPT("🍟",A1-5)&REPT("░",10-A1))

🥔🥔🥔🥔🥔🍟🍟🍟░░

IF REPT

Tomato to pizza

Put cook progress 0-10 in A1. Tomatoes sauce up into a hot pizza.

=IF(A1<=5,REPT("🍅",A1)&REPT("░",10-A1),REPT("🍅",5)&REPT("🍕",A1-5)&REPT("░",10-A1))

🍅🍅🍅🍅🍅🍕🍕🍕░░

IF REPT

Bees to honey

Put pollination progress 0-10 in A1. Bees buzz, then honey fills the jar.

=IF(A1<=5,REPT("🐝",A1)&REPT("░",10-A1),REPT("🐝",5)&REPT("🍯",A1-5)&REPT("░",10-A1))

🐝🐝🐝🐝🐝🍯🍯🍯░░

IF REPT

Milk to cheese

Put aging progress 0-10 in A1. Milk curdles into cheese wheels.

=IF(A1<=5,REPT("🥛",A1)&REPT("░",10-A1),REPT("🥛",5)&REPT("🧀",A1-5)&REPT("░",10-A1))

🥛🥛🥛🥛🥛🧀🧀🧀░░

IF REPT

Corn to popcorn

Put pop progress 0-10 in A1. Kernels heat up and burst into popcorn.

=IF(A1<=4,REPT("🌽",A1)&REPT("░",10-A1),IF(A1<=7,REPT("🌽",4)&REPT("🔥",A1-4)&REPT("░",10-A1),REPT("🌽",4)&REPT("🔥",3)&REPT("🍿",A1-7)&REPT("░",10-A1)))

🌽🌽🌽🌽🔥🔥🔥🍿🍿░

IF REPT

Apple to pie

Put bake progress 0-10 in A1. Apples slice up into a fresh pie.

=IF(A1<=5,REPT("🍎",A1)&REPT("░",10-A1),REPT("🍎",5)&REPT("🥧",A1-5)&REPT("░",10-A1))

🍎🍎🍎🍎🍎🥧🥧🥧░░

IF REPT

Pig to bacon

Put cook progress 0-10 in A1. Pork sizzles into crispy bacon strips.

=IF(A1<=5,REPT("🐷",A1)&REPT("░",10-A1),REPT("🐷",5)&REPT("🥓",A1-5)&REPT("░",10-A1))

🐷🐷🐷🐷🐷🥓🥓🥓░░

IF REPT

Coal to diamond

Put pressure progress 0-10 in A1. Black coal compresses into diamonds.

=IF(A1<=5,REPT("⬛",A1)&REPT("░",10-A1),REPT("⬛",5)&REPT("💎",A1-5)&REPT("░",10-A1))

⬛⬛⬛⬛⬛💎💎💎░░

IF REPT

Lemon to lemonade

Put squeeze progress 0-10 in A1. Lemons juice up into cold lemonade.

=IF(A1<=5,REPT("🍋",A1)&REPT("░",10-A1),REPT("🍋",5)&REPT("🥤",A1-5)&REPT("░",10-A1))

🍋🍋🍋🍋🍋🥤🥤🥤░░

IF REPT

Seed to pumpkin

Put grow progress 0-10 in A1. Sprouts vine out into a giant pumpkin.

=IF(A1<=5,REPT("🌱",A1)&REPT("░",10-A1),REPT("🌱",5)&REPT("🎃",A1-5)&REPT("░",10-A1))

🌱🌱🌱🌱🌱🎃🎃🎃░░

IF REPT

Trash to recycling

Put sort progress 0-10 in A1. Waste bins empty into green recycling.

=IF(A1<=5,REPT("🗑️",A1)&REPT("░",10-A1),REPT("🗑️",5)&REPT("♻️",A1-5)&REPT("░",10-A1))

🗑️🗑️🗑️🗑️🗑️♻️♻️♻️░░

IF REPT

Letter to mailbox

Put delivery progress 0-10 in A1. Envelopes travel to the mailbox.

=IF(A1<=5,REPT("✉️",A1)&REPT("░",10-A1),REPT("✉️",5)&REPT("📬",A1-5)&REPT("░",10-A1))

✉️✉️✉️✉️✉️📬📬📬░░

IF REPT

Ore to gold

Put mining progress 0-10 in A1. Pickaxes strike rock, then gold appears.

=IF(A1<=3,REPT("⛏️",A1)&REPT("░",10-A1),IF(A1<=6,REPT("⛏️",3)&REPT("🪨",A1-3)&REPT("░",10-A1),REPT("⛏️",3)&REPT("🪨",3)&REPT("💰",A1-6)&REPT("░",10-A1)))

⛏️⛏️⛏️🪨🪨🪨💰💰░░

IF REPT

Brick to house

Put build progress 0-10 in A1. Bricks stack up into a finished home.

=IF(A1<=6,REPT("🧱",A1)&REPT("░",10-A1),REPT("🧱",6)&REPT("🏠",A1-6)&REPT("░",10-A1))

🧱🧱🧱🧱🧱🧱🏠🏠🏠░

IF REPT

Yarn to sweater

Put knit progress 0-10 in A1. Balls of yarn become a cozy sweater.

=IF(A1<=5,REPT("🧶",A1)&REPT("░",10-A1),REPT("🧶",5)&REPT("🧥",A1-5)&REPT("░",10-A1))

🧶🧶🧶🧶🧶🧥🧥🧥░░

IF REPT

Water to tea

Put steep progress 0-10 in A1. Water heats, brews, then pours into cups.

=IF(A1<=3,REPT("💧",A1)&REPT("░",10-A1),IF(A1<=6,REPT("💧",3)&REPT("🫖",A1-3)&REPT("░",10-A1),REPT("💧",3)&REPT("🫖",3)&REPT("🍵",A1-6)&REPT("░",10-A1)))

💧💧💧🫖🫖🫖🍵🍵░░

IF REPT

Rock to gem

Put polish progress 0-10 in A1. Rough stone cuts into a sparkling gem.

=IF(A1<=5,REPT("🪨",A1)&REPT("░",10-A1),REPT("🪨",5)&REPT("💎",A1-5)&REPT("░",10-A1))

🪨🪨🪨🪨🪨💎💎💎░░

IF REPT

Egg to omelette

Put cook progress 0-10 in A1. Eggs crack, hit the pan, then plate up.

=IF(A1<=3,REPT("🥚",A1)&REPT("░",10-A1),IF(A1<=6,REPT("🥚",3)&REPT("🍳",A1-3)&REPT("░",10-A1),REPT("🥚",3)&REPT("🍳",3)&REPT("🍽️",A1-6)&REPT("░",10-A1)))

🥚🥚🥚🍳🍳🍳🍽️🍽️░░

IF REPT

Sand to sandcastle

Put sculpt progress 0-10 in A1. Beach sand piles into a castle.

=IF(A1<=5,REPT("🏖️",A1)&REPT("░",10-A1),REPT("🏖️",5)&REPT("🏰",A1-5)&REPT("░",10-A1))

🏖️🏖️🏖️🏖️🏖️🏰🏰🏰░░

IF REPT

Flour to cake

Put bake progress 0-10 in A1. Flour mixes, bakes, then becomes cake.

=IF(A1<=3,REPT("🌾",A1)&REPT("░",10-A1),IF(A1<=6,REPT("🌾",3)&REPT("🔥",A1-3)&REPT("░",10-A1),REPT("🌾",3)&REPT("🔥",3)&REPT("🎂",A1-6)&REPT("░",10-A1)))

🌾🌾🌾🔥🔥🔥🎂🎂░░

IF REPT

Cash to bank

Put deposit progress 0-10 in A1. Bills stack up, then land in the bank.

=IF(A1<=3,REPT("💵",A1)&REPT("░",10-A1),IF(A1<=6,REPT("💵",3)&REPT("💰",A1-3)&REPT("░",10-A1),REPT("💵",3)&REPT("💰",3)&REPT("🏦",A1-6)&REPT("░",10-A1)))

💵💵💵💰💰💰🏦🏦░░

IF REPT

Coins to piggy bank

Put savings progress 0-10 in A1. Coins clink in until the piggy bank is full.

=IF(A1<=6,REPT("🪙",A1)&REPT("░",10-A1),REPT("🪙",6)&REPT("🐷",A1-6)&REPT("░",10-A1))

🪙🪙🪙🪙🪙🪙🐷🐷🐷░

IF REPT

Paycheck to savings

Put save progress 0-10 in A1. Pay arrives, cash stacks, then hits the vault.

=IF(A1<=3,REPT("💼",A1)&REPT("░",10-A1),IF(A1<=6,REPT("💼",3)&REPT("💵",A1-3)&REPT("░",10-A1),REPT("💼",3)&REPT("💵",3)&REPT("🏦",A1-6)&REPT("░",10-A1)))

💼💼💼💵💵💵🏦🏦░░

IF REPT

Wallet to bank

Put transfer progress 0-10 in A1. Cash leaves the wallet and reaches the bank.

=IF(A1<=5,REPT("👛",A1)&REPT("░",10-A1),REPT("👛",5)&REPT("🏦",A1-5)&REPT("░",10-A1))

👛👛👛👛👛🏦🏦🏦░░

IF REPT

Cart to checkout

Put shop progress 0-10 in A1. Groceries fill the cart, then you pay at checkout.

=IF(A1<=6,REPT("🛒",A1)&REPT("░",10-A1),REPT("🛒",6)&REPT("💳",A1-6)&REPT("░",10-A1))

🛒🛒🛒🛒🛒🛒💳💳💳░

IF REPT

Invoice to paid

Put billing progress 0-10 in A1. Invoices clear, then payment lands.

=IF(A1<=4,REPT("📄",A1)&REPT("░",10-A1),IF(A1<=7,REPT("📄",4)&REPT("✅",A1-4)&REPT("░",10-A1),REPT("📄",4)&REPT("✅",3)&REPT("💰",A1-7)&REPT("░",10-A1)))

📄📄📄📄✅✅✅💰💰░

IF REPT

Rain to rainbow

Put clearing progress 0-10 in A1. Storm clouds break into a rainbow.

=IF(A1<=5,REPT("🌧️",A1)&REPT("░",10-A1),REPT("🌧️",5)&REPT("🌈",A1-5)&REPT("░",10-A1))

🌧️🌧️🌧️🌧️🌧️🌈🌈🌈░░

IF REPT

Night to day

Put dawn progress 0-10 in A1. Moon fades as the sun rises.

=IF(A1<=5,REPT("🌙",A1)&REPT("░",10-A1),REPT("🌙",5)&REPT("☀️",A1-5)&REPT("░",10-A1))

🌙🌙🌙🌙🌙☀️☀️☀️░░

IF REPT

Candle to light bulb

Put upgrade progress 0-10 in A1. Candle flame gives way to electric light.

=IF(A1<=5,REPT("🕯️",A1)&REPT("░",10-A1),REPT("🕯️",5)&REPT("💡",A1-5)&REPT("░",10-A1))

🕯️🕯️🕯️🕯️🕯️💡💡💡░░

IF REPT

Wood to paper

Put mill progress 0-10 in A1. Logs pulp down into sheets of paper.

=IF(A1<=5,REPT("🪵",A1)&REPT("░",10-A1),REPT("🪵",5)&REPT("📄",A1-5)&REPT("░",10-A1))

🪵🪵🪵🪵🪵📄📄📄░░

IF REPT

Sheep to yarn

Put shear progress 0-10 in A1. Wool clips off the flock into yarn balls.

=IF(A1<=5,REPT("🐑",A1)&REPT("░",10-A1),REPT("🐑",5)&REPT("🧶",A1-5)&REPT("░",10-A1))

🐑🐑🐑🐑🐑🧶🧶🧶░░

IF REPT

Oil barrel to gas pump

Put refine progress 0-10 in A1. Crude oil becomes fuel at the pump.

=IF(A1<=5,REPT("🛢️",A1)&REPT("░",10-A1),REPT("🛢️",5)&REPT("⛽",A1-5)&REPT("░",10-A1))

🛢️🛢️🛢️🛢️🛢️⛽⛽⛽░░

IF REPT

Seed to apple tree

Put orchard progress 0-10 in A1. Sprouts grow into trees heavy with apples.

=IF(A1<=3,REPT("🌱",A1)&REPT("░",10-A1),IF(A1<=6,REPT("🌱",3)&REPT("🌳",A1-3)&REPT("░",10-A1),REPT("🌱",3)&REPT("🌳",3)&REPT("🍎",A1-6)&REPT("░",10-A1)))

🌱🌱🌱🌳🌳🌳🍎🍎░░

IF REPT

Idea to rocket launch

Put startup progress 0-10 in A1. Lightbulb moments lift off into launch.

=IF(A1<=5,REPT("💡",A1)&REPT("░",10-A1),REPT("💡",5)&REPT("🚀",A1-5)&REPT("░",10-A1))

💡💡💡💡💡🚀🚀🚀░░

IF REPT

Pen to published book

Put writing progress 0-10 in A1. Drafts scribble out into a finished book.

=IF(A1<=5,REPT("🖊️",A1)&REPT("░",10-A1),REPT("🖊️",5)&REPT("📖",A1-5)&REPT("░",10-A1))

🖊️🖊️🖊️🖊️🖊️📖📖📖░░

IF REPT

Grapes to jam jar

Put preserve progress 0-10 in A1. Grape clusters cook down into jam.

=IF(A1<=5,REPT("🍇",A1)&REPT("░",10-A1),REPT("🍇",5)&REPT("🫙",A1-5)&REPT("░",10-A1))

🍇🍇🍇🍇🍇🫙🫙🫙░░

IF REPT

Clay to pottery

Put kiln progress 0-10 in A1. Wet clay fires into finished pottery.

=IF(A1<=4,REPT("🟤",A1)&REPT("░",10-A1),IF(A1<=7,REPT("🟤",4)&REPT("🔥",A1-4)&REPT("░",10-A1),REPT("🟤",4)&REPT("🔥",3)&REPT("🏺",A1-7)&REPT("░",10-A1)))

🟤🟤🟤🟤🔥🔥🔥🏺🏺░

IF REPT

Paint to masterpiece

Put art progress 0-10 in A1. Palette strokes become a framed painting.

=IF(A1<=5,REPT("🎨",A1)&REPT("░",10-A1),REPT("🎨",5)&REPT("🖼️",A1-5)&REPT("░",10-A1))

🎨🎨🎨🎨🎨🖼️🖼️🖼️░░

IF REPT

Homework to diploma

Put study progress 0-10 in A1. Books stack up into a graduation diploma.

=IF(A1<=6,REPT("📚",A1)&REPT("░",10-A1),REPT("📚",6)&REPT("🎓",A1-6)&REPT("░",10-A1))

📚📚📚📚📚📚🎓🎓🎓░

IF REPT

Question to answer

Put solve progress 0-10 in A1. Puzzles click from questions into answers.

=IF(A1<=5,REPT("❓",A1)&REPT("░",10-A1),REPT("❓",5)&REPT("✅",A1-5)&REPT("░",10-A1))

❓❓❓❓❓✅✅✅░░

IF REPT

Maple sap to syrup

Put boil progress 0-10 in A1. Sap drips from leaves into golden syrup.

=IF(A1<=5,REPT("🍁",A1)&REPT("░",10-A1),REPT("🍁",5)&REPT("🍯",A1-5)&REPT("░",10-A1))

🍁🍁🍁🍁🍁🍯🍯🍯░░

IF REPT

Sunrise over horizon

Put time of day 0-10 in A1. Sunrise moves across the sky.

=REPT("·",A1)&"🌅"&REPT("·",MAX(0,10-A1))

····🌅······

REPT MAX

Time of day sky

Put hour progress 0-10 in A1. Sunrise, midday sun, or sunset as the day moves.

=REPT("·",A1)&IF(A1<=3,"🌅",IF(A1<=7,"☀️","🌇"))&REPT("·",MAX(0,10-A1))

····☀️·····

REPT MAX IF

Penguin march line

Put penguin count in A1. Marching line with dots.

=REPT("🐧",A1)&REPT("·",MAX(0,6-A1))

🐧🐧🐧···

REPT MAX

Car trip to mountain (arrow trail)

Put trip progress 0-10 in A1. Arrow waypoints trail the car toward the mountain.

="🏔️"&REPT("←",MAX(0,10-A1))&"🚗"&REPT("・",MAX(0,A1-2))

🏔️←←←←←←🚗・・

REPT MAX

Car trip to McDonald's (arrow trail)

Put trip progress 0-10 in A1. Arrow waypoints trail the car toward the fries.

="🍟"&REPT("←",MAX(0,10-A1))&"🚗"&REPT("・",MAX(0,A1-2))

🍟←←←←←←🚗・・

REPT MAX

Burger run by car (arrow trail)

Put trip progress 0-10 in A1. Arrow waypoints trail the car toward a hamburger.

="🍔"&REPT("←",MAX(0,10-A1))&"🚗"&REPT("・",MAX(0,A1-2))

🍔←←←←←←🚗・・

REPT MAX

Soda run to drink break (arrow trail)

Put break progress 0-10 in A1. Arrow waypoints trail the soda toward a drink break.

="☕"&REPT("←",MAX(0,10-A1))&"🥤"&REPT("・",MAX(0,A1-2))

☕←←←←←←🥤・・

REPT MAX

Snack run to snack break (arrow trail)

Put break progress 0-10 in A1. Arrow waypoints trail the snack toward popcorn.

="🍿"&REPT("←",MAX(0,10-A1))&"🍪"&REPT("・",MAX(0,A1-2))

🍿←←←←←←🍪・・

REPT MAX

Snail race to finish (arrow trail)

Put lap position 0-10 in A1. Arrow waypoints show where the snail has already crawled.

=REPT("←",A1)&"🐌"&REPT("・",MAX(0,10-A1))&"🏁"

←←←🐌・・・・・🏁

REPT MAX

Rocket launch pad (arrow trail)

Higher A1 adds more flame blocks under the rocket. Arrow waypoints mark the pad approach.

=REPT("←",MAX(0,8-A1))&"🚀"&REPT(CHAR(9650),A1)

←←←←←🚀▲▲▲

REPT MAX CHAR

Pin map journey (arrow trail)

Put progress 0-10 in A1. Arrow waypoints show the route behind the pin.

=REPT("←",A1)&"📍"&REPT("・",MAX(0,10-A1))&"🏠"

←←←📍・・・・🏠

REPT MAX

Ship sailing home (ripple trail)

Put progress 0-8 in A1. Ripple waves trail behind the boat, ocean ahead.

=REPT("〰️",A1)&"⛵"&REPT("🌊",MAX(0,8-A1))

〰️〰️〰️⛵🌊🌊🌊🌊

REPT MAX

Sunrise over horizon (arrow trail)

Put time of day 0-10 in A1. Arrow waypoints mark the sunrise path across the sky.

=REPT("←",A1)&"🌅"&REPT("・",MAX(0,10-A1))

←←←←🌅・・・・・

REPT MAX

Time of day sky (arrow trail)

Put hour progress 0-10 in A1. Arrow waypoints trail sunrise, midday sun, or sunset.

=REPT("←",A1)&IF(A1<=3,"🌅",IF(A1<=7,"☀️","🌇"))&REPT("・",MAX(0,10-A1))

←←←←☀️・・・・・

REPT MAX IF

Penguin march line (arrow trail)

Put penguin count in A1. Arrow waypoints mark the march behind the flock.

=REPT("🐧",A1)&REPT("←",MAX(0,6-A1))

🐧🐧🐧←←←

REPT MAX

Butterfly garden count

Put butterfly count 0-5 in A1.

=REPT("🦋",A1)&REPT("🌸",5-A1)

🦋🦋🦋🌸🌸

REPT

X-wing Death Star trench run

Put lap position 0-10 in A1. Fighter closes on the Death Star.

=REPT("・",A1)&"＞🛸＜"&REPT("・",MAX(0,10-A1))&"🌑"

・・＞🛸＜・・・・🌑

REPT MAX

Millennium Falcon Kessel Run

Put parsecs 0-10 in A1. More stars means faster through hyperspace.

=REPT("✨",A1)&"🚀"&REPT("✨",MAX(0,10-A1))

✨✨✨🚀✨✨✨✨✨✨

REPT MAX

Hyperspace jump streak

Put jump progress 0-10 in A1. Sparkles trail the rocket.

=REPT("✨",A1)&REPT("・",MAX(0,10-A1))&"🚀"

✨✨✨✨・・・・🚀

REPT MAX

Rescue Princess Leia

Put rescue progress 0-10 in A1. Ship races toward the princess.

=REPT("・",MAX(0,10-A1))&"👸"&REPT("・",A1)&"🚀"

・・・・・👸・・・🚀

REPT MAX

Escape from Hoth

Put launch progress 0-10 in A1. Ship lifts off the ice planet.

=REPT("・",A1)&"🚀"&REPT("・",MAX(0,10-A1))&"❄️"

・・🚀・・・・・・❄️

REPT MAX

Tatooine desert crossing

Put journey progress 0-10 in A1. Cross the dunes to twin suns.

=🏜️&REPT("・",MAX(0,10-A1))&"🤖"&REPT("・",A1)&"☀️"

🏜️・・・・・🤖・・・☀️

REPT MAX

Podrace lap counter

Put laps completed in A1.

=REPT("🏎️",A1)&REPT("・",MAX(0,6-A1))&"🏁"

🏎️🏎️🏎️・・・🏁

REPT MAX

Asteroid field dodge run

Put asteroids dodged 0-8 in A1. Ship escapes at the end.

=REPT("☄️",A1)&REPT("・",MAX(0,8-A1))&"🚀"

☄️☄️☄️・・・🚀

REPT MAX

Hoth asteroid field density

Put field density 0-5 in A1. More rocks and comets mean tougher flying.

=REPT("🪨",A1)&REPT("☄️",MAX(0,5-A1))

🪨🪨🪨☄️☄️

REPT MAX

Falcon weaving through asteroids

Put dodge progress 0-6 in A1. Ship threads between rocks in the belt.

=REPT("🪨",MAX(0,6-A1))&"🚀"&REPT("🪨",A1)

🪨🪨🪨🚀🪨🪨🪨

REPT MAX

Slave I asteroid pursuit

Put pursuit progress 0-8 in A1. Boba Fett chases the Falcon through the rocks.

=REPT("🪨",A1)&"🛸"&REPT("・",MAX(0,8-A1))&"🚀"

🪨🪨🪨🛸・・・🚀

REPT MAX

Exogorth cave approach

Put danger 0-5 in A1. The space slug lurks inside the asteroid.

=REPT("🪨",MAX(0,5-A1))&"🕳️"&REPT("🐍",A1)

🪨🪨🕳️🐍🐍🐍

REPT MAX

Comet tail flyby streak

Put comets passed 0-5 in A1. Ice tails flash past the cockpit.

=REPT("☄️",A1)&REPT("✨",MAX(0,5-A1))&"🚀"

☄️☄️☄️✨✨🚀

REPT MAX

Asteroid hideout stealth

Put hidden time 0-6 in A1. Falcon tucked inside the rock, sensors watching.

=REPT("🪨",MAX(0,6-A1))&"🚀"&REPT("🪨",A1)&"👀"

🪨🪨🪨🚀🪨🪨👀

REPT MAX

Asteroid collision warning

Put near-misses 0-5 in A1. More warnings mean closer calls.

=REPT("⚠️",A1)&REPT("☄️",MAX(0,5-A1))

⚠️⚠️⚠️☄️☄️

REPT MAX

TIE fighters lost in asteroids

Put Imperial losses 0-5 in A1. Explosions among the rocks.

=REPT("💥",A1)&REPT("☄️",MAX(0,5-A1))&" Imperial losses"

💥💥💥☄️☄️ Imperial losses

REPT MAX

Asteroid belt traversal

Put distance cleared 0-8 in A1. Rocks thin as you escape the field.

=REPT("🪨",MAX(0,8-A1))&REPT("・",A1)&"✅"

🪨🪨🪨🪨・・・✅

REPT MAX

Comet dodge difficulty

Put difficulty 0-5 in A1. Filled comets mean a wild ride.

=REPT("☄️",A1)&REPT("○",5-A1)

☄️☄️☄️○○

REPT

Hyperspace blocked by asteroids

Put 1 to jump, 0 if the asteroid field blocks lightspeed.

=IF(A1>0,"🚀 Jump clear","☄️ Asteroids! Stay on sublights")

☄️ Asteroids! Stay on sublights

IF

Asteroid hull damage meter

Put damage hits 0-5 in A1. Comet strikes chip away at the hull.

=REPT("🚀",1)&REPT("💥",A1)&REPT("○",5-A1)

🚀💥💥💥○○

REPT

Bounty hunter pursuit

Put pursuit progress 0-10 in A1. Target closes on the payout.

=REPT("・",MAX(0,10-A1))&"🎯"&REPT("・",A1)&"💰"

・・・・・🎯・・・💰

REPT MAX

Sarlacc pit fall

Put fall progress 0-10 in A1. One step closer to the Sarlacc.

=REPT("・",A1)&"👤"&REPT("・",MAX(0,10-A1))&"🕳️"

・・👤・・・・・・🕳️

REPT MAX

Death Star exhaust port shot

Put aim progress 0-10 in A1. Proton torpedo homes in on the target.

=REPT("・",MAX(0,10-A1))&"🎯"&REPT("・",A1)&"💥"

・・・・・🎯・・・💥

REPT MAX

AT-AT march on Hoth

Put march progress 0-10 in A1. Walker advances across the ice.

=REPT("・",A1)&"🤖"&REPT("・",MAX(0,10-A1))&"❄️"

・・・🤖・・・・・❄️

REPT MAX

Endor shield generator raid

Put raid progress 0-10 in A1. Squad pushes through the forest.

=REPT("🌲",A1)&"🛡️"&REPT("・",MAX(0,10-A1))&"💥"

🌲🌲🌲🛡️・・・・・💥

REPT MAX

Mustafar duel intensity

Put duel intensity in A1. Flames flank crossed sabers.

=REPT("🔥",A1)&"⚔️"&REPT("🔥",MAX(0,5-A1))

🔥🔥🔥⚔️🔥🔥

REPT MAX

Emperor force lightning

Put lightning level 0-5 in A1.

=REPT("⚡",A1)&REPT("○",5-A1)&" 👑"

⚡⚡⚡○○ 👑

REPT

Force power meter

Put force level 0-5 in A1.

=REPT("✨",A1)&REPT("○",5-A1)

✨✨✨○○

REPT

Force lightning intensity

Put lightning bolts 0-5 in A1.

=REPT("⚡",A1)&REPT("○",5-A1)

⚡⚡⚡○○

REPT

Lightsaber training progress

Put training level 0-5 in A1.

=REPT("⚔️",A1)&REPT("○",5-A1)

⚔️⚔️⚔️○○

REPT

Kyber crystal charge

Put crystal charge 0-5 in A1.

=REPT("💎",A1)&REPT("○",5-A1)

💎💎💎○○

REPT

Rebel alliance star rating

Put rebel rating 0-5 in A1.

=REPT("⭐",A1)&REPT("☆",5-A1)&" Rebel"

⭐⭐⭐☆☆ Rebel

REPT

Death Star construction progress

Put build progress 0-10 in A1.

=REPT(CHAR(9608),A1)&REPT("░",10-A1)&" 🌑"

██████░░░░ 🌑

REPT CHAR

Shield generator health

Put hull integrity 0-10 in A1.

=REPT("█",A1)&REPT("░",10-A1)&" 🛡️"

██████░░░░ 🛡️

REPT

Carbonite freezing progress

Put freeze progress 0-10 in A1.

=REPT("█",A1)&REPT("░",10-A1)&" 🧊"

██████░░░░ 🧊

REPT

Droid army counter

Put droid count 0-5 in A1.

=REPT("🤖",A1)&REPT("○",5-A1)

🤖🤖🤖○○

REPT

Stormtrooper squad size

Put squad size 0-5 in A1.

=REPT("🪖",A1)&REPT("○",5-A1)

🪖🪖🪖○○

REPT

Clone trooper battalion

Put clone count in A1.

=REPT("🪖",A1)&" clones"

🪖🪖🪖 clones

REPT

TIE fighter formation

Put fighter count in A1.

=REPT("🛸",A1)&REPT("・",MAX(0,6-A1))

🛸🛸🛸・・・

REPT MAX

Star Destroyer fleet count

Put destroyer count in A1.

=REPT("🛸",A1)&" Imperial fleet"

🛸🛸🛸 Imperial fleet

REPT

Rebel starfighter squadron

Put squadron size in A1.

=REPT("⭐",A1)&REPT("🛸",MIN(A1,3))

⭐⭐⭐🛸🛸🛸

REPT MIN

R2-D2 beep meter

Put beep level 0-5 in A1.

=REPT("🤖",1)&REPT("●",A1)&REPT("○",5-A1)

🤖●●●○○

REPT

BB-8 roll distance

Put roll distance 0-10 in A1.

=REPT("🤖",1)&REPT("●",A1)&REPT("○",MAX(0,10-A1))

🤖●●●●○○○○○○

REPT MAX

C-3PO worry level

Put worry level in A1. More droids, more panic.

=REPT("🤖",A1)&" Oh my!"

🤖🤖🤖 Oh my!

REPT

Porg infestation count

Put porg count in A1.

=REPT("🐦",A1)&" porgs"

🐦🐦🐦 porgs

REPT

Baby Yoda soup rating

Put rating 1-5 in A1.

=REPT("🥣",1)&REPT("⭐",A1)&REPT("☆",5-A1)

🥣⭐⭐⭐☆☆

REPT

Mandalorian beskar armor

Put armor plates 0-5 in A1.

=REPT("🛡️",A1)&REPT("○",5-A1)

🛡️🛡️🛡️○○

REPT

Light side vs dark side meter

Put light-side score 0-5 in A1. Angels vs devils.

=REPT("😇",A1)&REPT("😈",5-A1)

😇😇😇😈😈

REPT

Jedi or Sith alignment

Put Jedi, Sith, or anything else in A1.

=IF(A1="Jedi","😇 Light side",IF(A1="Sith","😈 Dark side","⚖ Neutral"))

😇 Light side

IF

Lightsaber color picker

Put number 1-5 in A1 for blade color.

=CHOOSE(A1,"🔵 Blue","🟢 Green","🔴 Red","🟣 Purple","⚪ White")

🔵 Blue

CHOOSE

Lightsaber duel winner

Put Jedi power 0-10 in A1. Over 5 means the Jedi wins.

=IF(A1>5,"😇 Jedi wins","😈 Sith wins")

😇 Jedi wins

IF

Hyperdrive motivator status

Put 1 for ready, 0 for broken.

=IF(A1>0,"🚀 Hyperspace ready","⚠️ Motivator shot")

🚀 Hyperspace ready

IF

Tractor beam strength

Put beam strength 0-5 in A1.

=REPT("◎",A1)&REPT("○",5-A1)&" tractor beam"

◎◎◎○○ tractor beam

REPT

Imperial loyalty meter

Put loyalty 0-5 in A1. Red vs black circles.

=REPT("🔴",A1)&REPT("⚫",5-A1)

🔴🔴🔴⚫⚫

REPT

Galactic Senate vote tally

Put yes votes in A1 out of 10.

=REPT("👍",A1)&REPT("👎",MAX(0,10-A1))

👍👍👍👍👎👎👎👎👎👎

REPT MAX

Death Star plans recovered

Put plans found 0-3 in A1. Scrolls point to the Death Star.

=REPT("📜",A1)&REPT("○",3-A1)&" → 🌑"

📜📜📜 → 🌑

REPT

Ewok victory celebration

Put celebration level in A1. Confetti and trees.

=REPT("🎉",A1)&REPT("🌲",MAX(0,3-A1))

🎉🎉🎉🌲

REPT MAX

Vader force choke reach

Put reach distance in A1. Hand to target.

=REPT("✋",1)&REPT("・",A1)&"💀"

✋・・・💀

REPT

Wookiee roar volume

Put roar volume in A1. Speaker plus block meter.

=REPT("🔊",A1)&REPT(CHAR(9601),MAX(0,5-A1))

🔊🔊🔊▁▁

REPT MAX CHAR

Escape pod launch sequence

Put launch progress 0-10 in A1.

=REPT("・",MAX(0,10-A1))&"🚀"&REPT("・",A1)&"🪐"

・・・・・🚀・・・🪐

REPT MAX

Order 66 execution count

Put execution count in A1.

=REPT("⚔️",A1)&" executed"

⚔️⚔️⚔️ executed

REPT

Yoda training patience

Put patience level 1-5 in A1.

=REPT("✨",A1)&" ...patience you must have"

✨✨✨ ...patience you must have

REPT

Han Solo parsecs brag

Put parsecs in A1.

=A1&" parsecs"&REPT("🚀",MIN(A1,3))

12 parsecs🚀🚀🚀

REPT MIN

Imperial March footsteps

Put step count in A1. Dum-dum rhythm text.

=REPT("🥾",A1)&" dum dum dum dum"

🥾🥾🥾 dum dum dum dum

REPT

Jabba palace audience

Put audience size in A1.

=REPT("💰",A1)&" palace"

💰💰💰 palace

REPT

Lightspeed skip damage risk

Put risk level 0-10 in A1. Over 8 adds an explosion.

=REPT("✨",MOD(A1,5))&"🚀"&REPT("💥",IF(A1>8,1,0))

✨✨🚀

REPT IF MOD

Luke watches the twin suns

Put steps toward the horizon 0-10 in A1. Luke on Tatooine at binary sunset.

=REPT("・",A1)&"🧑"&REPT("・",MAX(0,10-A1))&"☀️☀️"

・・・🧑・・・・・・☀️☀️

REPT MAX

Obi-Wan vs Vader duel

Put duel intensity 0-5 in A1. Crossed sabers on the Death Star.

=REPT("⚔️",A1)&REPT("○",5-A1)

⚔️⚔️⚔️○○

REPT

Yoda lifting the X-Wing

Put force focus 0-5 in A1. Sparkles lift the fighter from the swamp.

=REPT("✨",A1)&"🚀"

✨✨✨🚀

REPT

Luke's trench approach

Put trench position 0-10 in A1. X-Wing threads the Death Star trench.

=REPT("⬛",A1)&"🚀"&REPT("⬛",MAX(0,10-A1))&"🎯"

⬛⬛⬛🚀⬛⬛⬛⬛⬛⬛🎯

REPT MAX

Death Star charging laser

Put charge level 0-5 in A1. Green beams fill before the superlaser fires.

=REPT("🟢",A1)&REPT("⚪",5-A1)&" 🌑"

🟢🟢🟢⚪⚪ 🌑

REPT

TIE Fighter swarm

Put fighter count in A1. Imperial TIEs close on the rebel ship.

=REPT("🛸",A1)&" 🚀"

🛸🛸🛸 🚀

REPT

Rebel fleet assembling

Put ships rallied 0-5 in A1. X-Wings gather before the attack.

=REPT("🚀",A1)&REPT("⭐",MAX(0,5-A1))

🚀🚀🚀⭐⭐

REPT MAX

X-Wing attack run

Put run progress 0-10 in A1. Stars trail the fighter toward the target.

=REPT("⭐",A1)&"🚀"&REPT("・",MAX(0,10-A1))

⭐⭐⭐🚀・・・・・

REPT MAX

Falcon escaping hyperspace

Put jump streak 0-5 in A1. Millennium Falcon drops out of lightspeed.

=REPT("✨",A1)&"🚀💨"

✨✨✨🚀💨

REPT

Droid factory conveyor

Put assembly progress 0-5 in A1. Gears roll a droid down the line.

=REPT("⚙️",A1)&"🤖"

⚙️⚙️⚙️🤖

REPT

Clone army deployed

Put battalion size in A1. Clone troopers march into battle.

=REPT("🪖",A1)&" Clone Army"

🪖🪖🪖 Clone Army

REPT

Jedi Council approval

Put council votes 0-5 in A1. Green lights mean the mission is approved.

=REPT("🟢",A1)&REPT("⚪",5-A1)

🟢🟢🟢⚪⚪

REPT

Sith influence meter

Put dark-side pull 0-5 in A1. Red overtakes black as the Sith gain ground.

=REPT("🔴",A1)&REPT("⚫",5-A1)

🔴🔴🔴⚫⚫

REPT

Holocron unlocked

Put unlock progress 0-5 in A1. Blue holocron panels light up.

=REPT("🔷",A1)&REPT("⬜",5-A1)

🔷🔷🔷⬜⬜

REPT

Kylo Ren rage level

Put rage level 0-5 in A1. Anger builds in the mask.

=REPT("💢",A1)&REPT("○",5-A1)

💢💢💢○○

REPT

Darth Vader breathing

Put breath count in A1. The iconic respirator rhythm.

=REPT("😮‍💨",A1)

😮‍💨😮‍💨😮‍💨

REPT

Force ghost appearance

Put ghost count in A1. Obi-Wan, Yoda, or Anakin fade in.

=REPT("👻",A1)

👻👻

REPT

Ewok trap readiness

Put trap prep 0-5 in A1. Logs and trees on the forest moon of Endor.

=REPT("🪵",A1)&REPT("🌲",5-A1)

🪵🪵🪵🌲🌲

REPT

Speeder bike chase

Put trees passed 0-5 in A1. Scout troopers race through Endor.

=REPT("🌲",A1)&"🏍️"

🌲🌲🌲🏍️

REPT

Jabba's treasure pile

Put hoard size in A1. Gold stacks up beside the Hutt.

=REPT("💰",A1)&"🐌"

💰💰💰🐌

REPT

Carbonite thaw

Put thaw progress 0-10 in A1. Ice melts to reveal Han Solo.

=REPT("🧊",MAX(0,10-A1))&"👤"

🧊🧊🧊🧊🧊🧊🧊👤

REPT MAX

Sarlacc digestion

Put digestion stage in A1. Teeth at the edge of the Great Pit of Carkoon.

=REPT("🦷",A1)&"🕳️"

🦷🦷🦷🕳️

REPT

Boba Fett bounty tracker

Put targets locked 0-5 in A1. Crosshairs close on the payout.

=REPT("🎯",A1)&"💰"

🎯🎯🎯💰

REPT

Mandalorian bounty board

Put contracts posted in A1. Wanted posters stack up for the hunter.

=REPT("📜",A1)&"🪙"

📜📜📜🪙

REPT

Grogu snack count

Put snack count in A1. Grogu reaches for another egg.

=REPT("🥚",A1)

🥚🥚🥚

REPT

Jawa scrap haul

Put scrap pieces 0-5 in A1. Jawas haul droid parts across the dunes.

=REPT("⚙️",A1)&"🤎"

⚙️⚙️⚙️🤎

REPT

Sandcrawler inventory

Put crates loaded in A1. Jawa sandcrawler fills up before rolling out.

=REPT("📦",A1)&"🚚"

📦📦📦🚚

REPT

Blue milk rating

Put rating 0-5 in A1. Tatooine blue milk gets a star score.

=REPT("🥛",A1)&REPT("☆",5-A1)

🥛🥛🥛☆☆

REPT

Mos Eisley cantina crowd

Put crowd energy 0-5 in A1. Band horns and drinks at the cantina bar.

=REPT("🎺",A1)&"🍺"

🎺🎺🎺🍺

REPT

Cantina band intensity

Put band volume 0-5 in A1. Figrin D'an and the Modal Nodes crank up.

=REPT("🎷",A1)&REPT("🎺",MAX(0,5-A1))

🎷🎷🎷🎺🎺

REPT MAX

Force push distance

Put push distance 0-5 in A1. Shockwaves shove the target back.

=REPT("〰️",A1)&"👤"

〰️〰️〰️👤

REPT

Jedi meditation

Put meditation depth in A1. Padawans center themselves in the Force.

=REPT("🧘",A1)

🧘🧘🧘

REPT

Lightsaber crystal alignment

Put number 1-6 in A1 for kyber crystal color.

=CHOOSE(A1,"🔵","🟢","🟣","🟡","⚪","🔴")

🔵

CHOOSE

Bacta tank recovery

Put recovery progress 0-5 in A1. Luke heals in the bacta tank.

=REPT("💙",A1)&REPT("🤍",5-A1)

💙💙💙🤍🤍

REPT

Star Destroyer blockade

Put destroyer count in A1. Imperial ships ring the planet.

=REPT("🛸",A1)&"🪐"

🛸🛸🛸🪐

REPT

Shield generator charging

Put charge level 0-5 in A1. Endor shield powers up before the battle.

=REPT("🛡️",A1)&REPT("⚡",MAX(0,5-A1))

🛡️🛡️🛡️⚡⚡

REPT MAX

Thermal detonator countdown

Put seconds elapsed 0-10 in A1. Countdown to Leia's thermal detonator.

=10-A1&" 💣"

7 💣

Holo-message transmission

Put signal strength 0-5 in A1. Leia's distress call beams across space.

=REPT("📡",A1)&"👸"

📡📡📡👸

REPT

Rebel transmission strength

Put signal bars 0-5 in A1. Rebel comms punch through Imperial jamming.

=REPT("📶",A1)

📶📶📶

REPT

Imperial alert level

Put alert level 1-5 in A1. Death Star goes from green to red alert.

=CHOOSE(A1,"🟢","🟡","🟠","🔴","🚨")

🟠

CHOOSE

Force balance

Put light-side score 0-10 in A1. White and black sides of the Force.

=REPT("⚪",A1)&"⚖️"&REPT("⚫",10-A1)

⚪⚪⚪⚖️⚫⚫⚫⚫⚫⚫⚫

REPT

Binary sunset blinking

Animates with NOW(). Twin suns blink on Tatooine. No input needed.

=IF(MOD(NOW()*86400,2)=0,"☀️☀️","🌅")

☀️☀️

IF MOD NOW

R2-D2 beeping

Animates with NOW(). R2 cycles through colored indicator lights.

=CHOOSE(MOD(NOW()*86400,4)+1,"🤖","🤖🔵","🤖🔴","🤖🟢")

🤖🔵

CHOOSE MOD NOW

Lightsaber flicker

Animates with NOW(). Blade sparks on and off during the duel.

=IF(MOD(NOW()*86400,2)=0,"⚔️✨","⚔️")

⚔️✨

IF MOD NOW

Death Star charging

Animates with NOW(). Superlaser charge pulses on the Death Star.

=REPT("🟢",MOD(NOW()*86400,6))&"🌑"

🟢🟢🟢🌑

REPT MOD NOW

Hyperdrive charging

Animates with NOW(). Falcon hyperdrive motivator spins up.

=REPT("✨",MOD(NOW()*86400,8))&"🚀"

✨✨✨✨🚀

REPT MOD NOW

One Ring Mount Doom trek

Put journey progress 0-10 in A1. The ring closes on the volcano.

=🏔️&REPT("・",MAX(0,10-A1))&"💍"&REPT("・",A1)&"🌋"

🏔️・・・・・💍・・・🌋

REPT MAX

Fellowship march to Mordor

Put march progress 0-10 in A1. The fellowship pushes through the wild.

=REPT("🧝",1)&REPT("🧙",1)&REPT("🧔",1)&REPT("・",MAX(0,10-A1))&REPT("👣",A1)

🧝🧙🧔・・・・・👣👣👣

REPT MAX

Gandalf vs Balrog bridge duel

Put duel intensity 0-5 in A1. Flames rise on the bridge.

=REPT("🌉",1)&"🧙"&REPT("🔥",A1)&"👹"&REPT("🔥",MAX(0,5-A1))

🌉🧙🔥🔥🔥👹🔥🔥

REPT MAX

Helm's Deep battle line

Put defense strength 0-10 in A1. Shields and arrows hold the wall.

=REPT("🛡️",A1)&REPT("🏹",MAX(0,10-A1))&" 🏰"

🛡️🛡️🛡️🏹🏹🏹🏹 🏰

REPT MAX

Rohan cavalry charge

Put charge progress 0-10 in A1. Riders thunder toward the battle.

=REPT("🐴",A1)&REPT("・",MAX(0,10-A1))&"⚔️"

🐴🐴🐴・・・・・⚔️

REPT MAX

Orc army counter

Put orc count 0-5 in A1.

=REPT("👹",A1)&REPT("○",5-A1)

👹👹👹○○

REPT

Uruk-hai squad size

Put squad size 0-5 in A1.

=REPT("👹",A1)&" Uruk-hai"

👹👹👹 Uruk-hai

REPT

Legolas arrow volley

Put arrows fired 0-5 in A1.

=REPT("🏹",A1)&REPT("○",5-A1)

🏹🏹🏹○○

REPT

Gimli axe kill count

Put kill count in A1.

=REPT("🪓",A1)&" dwarf kills"

🪓🪓🪓 dwarf kills

REPT

Ent march on Isengard

Put march progress 0-6 in A1. Trees advance on the tower.

=REPT("🌳",A1)&REPT("・",MAX(0,6-A1))&"🏰"

🌳🌳🌳・・・🏰

REPT MAX

Great Eagles rescue flight

Put rescue progress 0-10 in A1. Eagles swoop toward the mountain.

=REPT("・",MAX(0,10-A1))&"🦅"&REPT("・",A1)&"⛰️"

・・・・・🦅・・・⛰️

REPT MAX

Sauron eye gaze intensity

Put gaze level 0-5 in A1.

=REPT("👁️",A1)&REPT("○",5-A1)

👁️👁️👁️○○

REPT

Palantir vision meter

Put visions seen 0-5 in A1.

=REPT("🔮",A1)&REPT("○",5-A1)

🔮🔮🔮○○

REPT

Mithril armor plates

Put armor plates 0-5 in A1.

=REPT("🛡️",A1)&REPT("○",5-A1)&" mithril"

🛡️🛡️🛡️○○ mithril

REPT

Hobbit second breakfast count

Put breakfast count in A1.

=REPT("🍞",A1)&" breakfasts"

🍞🍞🍞 breakfasts

REPT

Nazgul ringwraith pursuit

Put pursuit progress 0-10 in A1. Riders close on the ring bearer.

=REPT("・",A1)&"🏇"&REPT("・",MAX(0,10-A1))&"💍"

・・🏇・・・・・・💍

REPT MAX

Shelob web trap progress

Put web density 0-8 in A1. Spider closes in the tunnel.

=REPT("🕸️",A1)&REPT("・",MAX(0,8-A1))&"🕷️"

🕸️🕸️🕸️・・・🕷️

REPT MAX

Mines of Moria depth

Put depth level 0-10 in A1. Deeper into the dark mines.

=REPT("⛏️",A1)&REPT("・",MAX(0,10-A1))&"💀"

⛏️⛏️⛏️・・・・・💀

REPT MAX

Cave troll encounter

Put troll threat 0-5 in A1.

=REPT("👹",A1)&REPT("○",5-A1)&" troll"

👹👹👹○○ troll

REPT

Elven star light rating

Put elven rating 0-5 in A1.

=REPT("✨",A1)&REPT("☆",5-A1)&" Elven"

✨✨✨☆☆ Elven

REPT

Knight vs dragon duel

Put duel progress 0-5 in A1. Knight closes on the dragon.

=REPT("🛡️",1)&REPT("⚔️",A1)&REPT("・",MAX(0,5-A1))&"🐉"

🛡️⚔️⚔️⚔️・・🐉

REPT MAX

Dragon treasure hoard

Put gold piles in A1. Dragon guards the loot.

=REPT("💰",A1)&REPT("🐉",1)

💰💰💰🐉

REPT

Dragon fire breath meter

Put fire intensity 0-5 in A1.

=REPT("🔥",A1)&REPT("○",5-A1)&"🐉"

🔥🔥🔥○○🐉

REPT

Sword fight intensity

Put duel level 0-5 in A1.

=REPT("⚔️",A1)&REPT("○",5-A1)

⚔️⚔️⚔️○○

REPT

Castle siege progress

Put siege progress 0-10 in A1. Arrows rain on the castle.

=REPT("🏹",A1)&REPT("・",MAX(0,10-A1))&"🏰"

🏹🏹🏹・・・・・🏰

REPT MAX

Goblin ambush counter

Put goblin count in A1.

=REPT("👺",A1)&" goblins"

👺👺👺 goblins

REPT

Skeleton army march

Put skeleton count 0-5 in A1.

=REPT("💀",A1)&REPT("○",5-A1)

💀💀💀○○

REPT

Troll bridge toll

Put troll count under the bridge in A1.

=REPT("🌉",1)&REPT("👹",A1)&" trolls"

🌉👹👹👹 trolls

REPT

Unicorn meadow count

Put unicorn count 0-5 in A1. Flowers fill the meadow.

=REPT("🦄",A1)&REPT("🌸",5-A1)

🦄🦄🦄🌸🌸

REPT

Griffin mountain flight

Put flight progress 0-10 in A1. Griffin soars toward the peak.

=REPT("🦅",1)&REPT("・",A1)&"🏔️"

🦅・・・🏔️

REPT

Phoenix rebirth flames

Put rebirth intensity in A1. Flames build to the phoenix.

=REPT("🔥",A1)&"🦅"

🔥🔥🔥🦅

REPT

Hydra head count

Put heads remaining in A1.

=REPT("🐍",A1)&" heads"

🐍🐍🐍 heads

REPT

Werewolf moon howl

Put howl intensity in A1. Wolves answer the moon.

=REPT("🐺",A1)&REPT("🌙",1)

🐺🐺🐺🌙

REPT

Vampire bat swarm

Put bat count 0-5 in A1.

=REPT("🦇",A1)&REPT("○",5-A1)

🦇🦇🦇○○

REPT

Medusa stone gaze

Put gaze level 0-3 in A1. Victims turn to stone.

=REPT("🐍",A1)&"👁️"&REPT("🪨",MAX(0,3-A1))

🐍🐍👁️🪨

REPT MAX

Potion brewing progress

Put brew progress 0-5 in A1. Vials fill toward the finished potion.

=REPT("🧪",A1)&REPT(CHAR(9617),5-A1)&" 🧙"

🧪🧪🧪▒▒ 🧙

REPT CHAR

Spell casting power

Put mana level 0-5 in A1.

=REPT("✨",A1)&REPT("○",5-A1)&" mana"

✨✨✨○○ mana

REPT

Dungeon crawl depth

Put depth 0-10 in A1. Torches lead deeper into the crypt.

=REPT("🕯️",A1)&REPT("・",MAX(0,10-A1))&"💀"

🕯️🕯️🕯️・・・・・💀

REPT MAX

Enchanted forest path

Put path progress 0-5 in A1. Trees and fairies line the trail.

=REPT("🌲",A1)&REPT("✨",MAX(0,5-A1))&"🧚"

🌲🌲🌲✨✨🧚

REPT MAX

Wizard tower ascent

Put climb progress 0-10 in A1. Wizard climbs toward the tower top.

=REPT("・",MAX(0,10-A1))&"🧙"&REPT("・",A1)&"🗼"

・・・・・🧙・・・🗼

REPT MAX

Quest scroll tracker

Put quests completed 0-3 in A1.

=REPT("📜",A1)&REPT("○",3-A1)&" quests"

📜📜📜 quests

REPT

Tavern ale rating

Put ale mugs in A1. More mugs, better night at the tavern.

=REPT("🍺",A1)&REPT("⭐",MIN(A1,5))

🍺🍺🍺⭐⭐⭐

REPT MIN

Treasure chest loot count

Put gems found in A1.

=REPT("💎",A1)&REPT("📦",1)

💎💎💎📦

REPT

Battle axe squad

Put axe count 0-5 in A1.

=REPT("🪓",A1)&REPT("○",5-A1)

🪓🪓🪓○○

REPT

Shield wall formation

Put shield count 0-5 in A1.

=REPT("🛡️",A1)&REPT("○",5-A1)

🛡️🛡️🛡️○○

REPT

War camp fire intensity

Put campfire level in A1. Tents ring the flames.

=REPT("⛺",A1)&REPT("🔥",MAX(0,5-A1))

⛺⛺⛺🔥🔥

REPT MAX

Elven vs orc battle meter

Put elven strength 0-5 in A1. Elves push back the orcs.

=REPT("🧝",A1)&REPT("👹",5-A1)

🧝🧝🧝👹👹

REPT

Hero or villain alignment

Put alignment score 0-5 in A1. Over 3 means hero.

=IF(A1>3,"🦸 Hero","👹 Villain")

🦸 Hero

IF

Fantasy weapon picker

Put number 1-5 in A1 for weapon type.

=CHOOSE(A1,"⚔️ Sword","🏹 Bow","🪓 Axe","🔮 Staff","🛡️ Shield")

⚔️ Sword

CHOOSE

Dragon slayer victory

Put slayer power 0-10 in A1. Over 5 means the dragon falls.

=IF(A1>5,"⚔️ Dragon slain","🐉 Dragon wins")

⚔️ Dragon slain

IF

Mermaid lagoon count

Put mermaid count 0-5 in A1. Waves fill the lagoon.

=REPT("🧜",A1)&REPT("🌊",5-A1)

🧜🧜🧜🌊🌊

REPT

Kraken tentacle attack

Put tentacle count in A1. Tentacles rise from the deep.

=REPT("🐙",A1)&REPT("🌊",MAX(0,3-A1))

🐙🐙🐙

REPT MAX

Cyclops boulder throw

Put throw distance 0-10 in A1. Boulders fly toward the target.

=REPT("👁️",1)&REPT("🪨",A1)&REPT("・",MAX(0,10-A1))&"🎯"

👁️🪨🪨🪨・・・・・🎯

REPT MAX

Fairy dust sparkle trail

Put sparkle level 0-10 in A1. Fairy leaves a glitter trail.

=REPT("🧚",1)&REPT("✨",A1)&REPT("・",MAX(0,10-A1))

🧚✨✨✨✨・・・・・

REPT MAX

Excalibur drawn from the stone

Put pull strength 0-10 in A1. Sword rises from the stone.

=REPT("🪨",MAX(0,10-A1))&"⚔️"&REPT("✨",A1)

🪨🪨🪨🪨⚔️✨✨✨✨✨✨

REPT MAX

King Arthur's round table

Put knights seated 0-8 in A1.

=REPT("🛡️",A1)&" 🏰"

🛡️🛡️🛡️🛡️ 🏰

REPT

Dwarf gold mine

Put gold collected 0-10 in A1.

=REPT("⛏️",A1)&REPT("💰",MAX(0,10-A1))

⛏️⛏️⛏️💰💰💰💰💰💰💰

REPT MAX

Magic portal opening

Put portal power 0-5 in A1.

=REPT("🌀",A1)&REPT("○",5-A1)

🌀🌀🌀○○

REPT

Necromancer army raised

Put skeleton count 0-5 in A1.

=REPT("💀",A1)&REPT("⚰️",MAX(0,5-A1))

💀💀💀⚰️⚰️

REPT MAX

Dark tower corruption

Put corruption level 0-5 in A1.

=REPT("⚫",A1)&REPT("⚪",5-A1)&" 🏰"

⚫⚫⚫⚪⚪ 🏰

REPT

Wizard spellbook mastery

Put spells learned 0-10 in A1.

=REPT("📖",A1)&REPT("✨",MAX(0,10-A1))

📖📖📖✨✨✨✨✨✨✨

REPT MAX

Magic wand charge

Put charge level 0-5 in A1.

=REPT("✨",A1)&REPT("⚪",5-A1)&"🪄"

✨✨✨⚪⚪🪄

REPT

Crystal ball clarity

Put vision strength 0-5 in A1.

=REPT("🔮",A1)&REPT("🌫️",5-A1)

🔮🔮🔮🌫️🌫️

REPT

Treasure map completion

Put clues found 0-5 in A1.

=REPT("🗺️",A1)&REPT("❓",5-A1)

🗺️🗺️🗺️❓❓

REPT

Dungeon boss approach

Put room progress 0-10 in A1.

=REPT("🚪",A1)&REPT("・",MAX(0,10-A1))&"👹"

🚪🚪🚪・・・・・・・👹

REPT MAX

Mimic suspicion level

Put suspicion 0-5 in A1.

=REPT("📦",A1)&REPT("😈",MAX(0,5-A1))

📦📦📦😈😈

REPT MAX

Bard inspiration meter

Put inspiration 0-5 in A1.

=REPT("🎵",A1)&REPT("○",5-A1)

🎵🎵🎵○○

REPT

Tavern quest rumors

Put rumors heard 0-5 in A1.

=REPT("🍺",A1)&REPT("📜",MAX(0,5-A1))

🍺🍺🍺📜📜

REPT MAX

Rogue stealth level

Put stealth level 0-5 in A1.

=REPT("🗡️",A1)&REPT("🌑",5-A1)

🗡️🗡️🗡️🌑🌑

REPT

Ranger tracking progress

Put tracks found 0-10 in A1.

=REPT("👣",A1)&REPT("🌲",MAX(0,10-A1))

👣👣👣🌲🌲🌲🌲🌲🌲🌲

REPT MAX

Enchanted sword power

Put enchantment level 0-5 in A1.

=REPT("⚔️",A1)&REPT("✨",MAX(0,5-A1))

⚔️⚔️⚔️✨✨

REPT MAX

Dungeon key collection

Put keys found 0-5 in A1.

=REPT("🗝️",A1)&REPT("🚪",MAX(0,5-A1))

🗝️🗝️🗝️🚪🚪

REPT MAX

Dragon egg hatch progress

Put hatch progress 0-10 in A1.

=REPT("🥚",MAX(0,10-A1))&"🐣"&REPT("🔥",A1)

🥚🥚🥚🥚🐣🔥🔥🔥🔥🔥🔥

REPT MAX

Pegasus flight distance

Put flight progress 0-10 in A1.

=REPT("☁️",A1)&"🦄"&REPT("☁️",MAX(0,10-A1))

☁️☁️☁️🦄☁️☁️☁️☁️☁️☁️☁️

REPT MAX

Treasure chest lockpick

Put lockpick progress 0-5 in A1.

=REPT("🗝️",A1)&REPT("🔒",5-A1)

🗝️🗝️🗝️🔒🔒

REPT

Dungeon torch supply

Put torches remaining 0-5 in A1.

=REPT("🔥",A1)&REPT("🕯️",5-A1)

🔥🔥🔥🕯️🕯️

REPT

Magic academy grades

Put rank 1-5 in A1.

=CHOOSE(A1,"🧹 Apprentice","📖 Student","🪄 Mage","🔮 Wizard","🧙 Archmage")

🧙 Archmage

CHOOSE

Alignment meter

Put alignment 0-5 in A1.

=REPT("😇",A1)&REPT("😈",5-A1)

😇😇😇😈😈

REPT

Quest completion tracker

Put quests completed 0-10 in A1.

=REPT("✅",A1)&REPT("📜",MAX(0,10-A1))

✅✅✅📜📜📜📜📜📜📜

REPT MAX

Loot rarity picker

Put rarity 1-5 in A1.

=CHOOSE(A1,"⚪ Common","🟢 Uncommon","🔵 Rare","🟣 Epic","🟠 Legendary")

🟣 Epic

CHOOSE

Boss battle health bar

Put health 0-10 in A1.

=REPT("❤️",A1)&REPT("🖤",10-A1)&" 👹"

❤️❤️❤️❤️🖤🖤🖤🖤🖤🖤 👹

REPT

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