Google Sheets Emoji Scene Formulas

Car trip to mountain

Put current position in A1 and distance goal in B1 (e.g. 10). Car moves toward the mountain.

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

🏔️・・・・・・🚗・・

REPT MAX

Scene journey template

Put current position in A1 and distance goal in B1 (e.g. 10). The emoji travels along the bar toward the finish.

="🏁"&REPT("·",MAX(0,B1-A1))&"🚗"&REPT("·",MAX(0,A1-1))

🏁······🚗···

REPT MAX

Story stage template

Put stage 1-4 in A1. Each step shows one scene emoji, not a progress bar.

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

📖

CHOOSE

Car trip to McDonald's

Put current position in A1 and distance goal in B1 (e.g. 10). Car drives toward the fries.

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

🍟・・・・・・🚗・・

REPT MAX

Burger run by car

Put current position in A1 and distance goal in B1 (e.g. 10). Car drives toward a hamburger.

="🍔"&REPT("・",MAX(0,B1-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,B1-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,B1-A1))&"🍪"&REPT("・",MAX(0,A1-2))

🍿・・・・・・🍪・・

REPT MAX

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

Snail race to finish

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

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

···🐌······🏁

REPT MAX

Rocket launch pad

Higher A1 adds more flame blocks under the rocket.

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

·····🚀▲▲▲

REPT MAX CHAR

Pin map journey

Put current value in A1 and goal in B1 (e.g. 10 for a ten-step bar). Pin travels toward home.

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

···📍····🏠

REPT MAX

Ship sailing home

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

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

🌊🌊🌊⛵🌊🌊🌊🌊

REPT MAX

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

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

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

Rocket launch story

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

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

🚀

CHOOSE

Ocean depth zones

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

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

🐙

CHOOSE

Seed to sunflower

Put growth stage 1-5 in A1.

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

🌻

CHOOSE

Sunrise over horizon

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

=REPT("·",MIN(A1,B1))&"🌅"&REPT("·",MAX(0,B1-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,B1-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 current position in A1 and distance goal in B1 (e.g. 10). Arrow waypoints trail the car toward the mountain.

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

🏔️←←←←←←🚗・・

REPT MAX

Car trip to McDonald's (arrow trail)

Put current position in A1 and distance goal in B1 (e.g. 10). Arrow waypoints trail the car toward the fries.

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

🍟←←←←←←🚗・・

REPT MAX

Burger run by car (arrow trail)

Put current position in A1 and distance goal in B1 (e.g. 10). Arrow waypoints trail the car toward a hamburger.

="🍔"&REPT("←",MAX(0,B1-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,B1-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,B1-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,B1-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,B1-A1))&"🚀"&REPT(CHAR(9650),A1)

←←←←←🚀▲▲▲

REPT MAX CHAR

Pin map journey (arrow trail)

Put current value in A1 and goal in B1 (e.g. 10 for a ten-step bar). Arrow waypoints show the route behind the pin.

=REPT("←",A1)&"📍"&REPT("・",MAX(0,B1-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,B1-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,B1-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,B1-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

Habit journey to goal

Put progress 0-10 in A1. Seed trail grows from sprout to full bloom.

=REPT("🌱",MIN(A1,B1))&REPT("·",MAX(0,B1-A1))&REPT("🌻",IF(A1>=B1,1,0))

🌱🌱🌱🌱🌱·····

REPT MIN MAX IF

Car trip to mountain

Scene journey template

Story stage template

Car trip to McDonald's

Burger run by car

Soda run to drink break

Snack run to snack break

Tree growth stages

Growth completion by percentage

Snail race to finish

Rocket launch pad

Pin map journey

Ship sailing home

Chicken life cycle

Butterfly metamorphosis

Storm brewing phases

Four seasons

Day arc phases

Water cycle phases

Project lifecycle

Treasure hunt story

Soup cooking story

Pizza baking stages

Snowman building

Rocket launch story

Ocean depth zones

Seed to sunflower

Sunrise over horizon

Time of day sky

Penguin march line

Car trip to mountain (arrow trail)

Car trip to McDonald's (arrow trail)

Burger run by car (arrow trail)

Soda run to drink break (arrow trail)

Snack run to snack break (arrow trail)

Snail race to finish (arrow trail)

Rocket launch pad (arrow trail)

Pin map journey (arrow trail)

Ship sailing home (ripple trail)

Sunrise over horizon (arrow trail)

Time of day sky (arrow trail)

Penguin march line (arrow trail)

Habit journey to goal

Related formula guides

Go deeper with Better Sheets