Galactic journey and progress formulas. Click a card to copy.

Fan-inspired sheet art. Not affiliated with or endorsed by Lucasfilm Ltd.

X-wing Death Star trench run

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

=REPT("・",A1)&">🛸<"&REPT("・",MAX(0,B1-A1))&"🌑"

・・>🛸<・・・・🌑

Death Star construction progress

Put build progress 0-10 in A1.

=REPT(CHAR(9608),A1)&REPT("░",MAX(0,B1-A1))&" 🌑"

██████░░░░ 🌑

Hyperspace jump streak

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

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

✨✨✨✨・・・・🚀

Rebel fleet assembling

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

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

🚀🚀🚀⭐⭐

Lightsaber training progress

Put training level 0-5 in A1.

=REPT("⚔️",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))

⚔️⚔️⚔️○○

Death Star exhaust port shot

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

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

・・・・・🎯・・・💥

Millennium Falcon Kessel Run

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

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

✨✨✨🚀✨✨✨✨✨✨

Rescue Princess Leia

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

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

・・・・・👸・・・🚀

Escape from Hoth

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

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

・・🚀・・・・・・❄️

Tatooine desert crossing

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

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

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

Podrace lap counter

Put laps completed in A1.

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

🏎️🏎️🏎️・・・🏁

Asteroid field dodge run

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

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

☄️☄️☄️・・・🚀

Hoth asteroid field density

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

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

🪨🪨🪨☄️☄️

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)

🪨🪨🪨🚀🪨🪨🪨

Slave I asteroid pursuit

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

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

🪨🪨🪨🛸・・・🚀

Exogorth cave approach

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

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

🪨🪨🕳️🐍🐍🐍

Comet tail flyby streak

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

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

☄️☄️☄️✨✨🚀

Asteroid hideout stealth

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

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

🪨🪨🪨🚀🪨🪨👀

Asteroid collision warning

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

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

⚠️⚠️⚠️☄️☄️

TIE fighters lost in asteroids

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

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

💥💥💥☄️☄️ Imperial losses

Asteroid belt traversal

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

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

🪨🪨🪨🪨・・・✅

Comet dodge difficulty

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

=REPT("☄️",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))

☄️☄️☄️○○

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("○",MAX(0,B1-A1))

🚀💥💥💥○○

Bounty hunter pursuit

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

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

・・・・・🎯・・・💰

Sarlacc pit fall

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

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

・・👤・・・・・・🕳️

AT-AT march on Hoth

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

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

・・・🤖・・・・・❄️

Endor shield generator raid

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

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

🌲🌲🌲🛡️・・・・・💥

Mustafar duel intensity

Put duel intensity in A1. Flames flank crossed sabers.

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

🔥🔥🔥⚔️🔥🔥

Emperor force lightning

Put lightning level 0-5 in A1.

=REPT("⚡",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" 👑"

⚡⚡⚡○○ 👑

Force power meter

Put force level 0-5 in A1.

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

✨✨✨○○

Force lightning intensity

Put lightning bolts 0-5 in A1.

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

⚡⚡⚡○○

Kyber crystal charge

Put crystal charge 0-5 in A1.

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

💎💎💎○○

Rebel alliance star rating

Put rebel rating 0-5 in A1.

=REPT("⭐",MIN(A1,B1))&REPT("☆",MAX(0,B1-A1))&" Rebel"

⭐⭐⭐☆☆ Rebel

Shield generator health

Put hull integrity 0-10 in A1.

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

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

Carbonite freezing progress

Put freeze progress 0-10 in A1.

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

██████░░░░ 🧊

Droid army counter

Put droid count 0-5 in A1.

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

🤖🤖🤖○○

Stormtrooper squad size

Put squad size 0-5 in A1.

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

🪖🪖🪖○○

Clone trooper battalion

Put clone count in A1.

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

🪖🪖🪖 clones

TIE fighter formation

Put fighter count in A1.

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

🛸🛸🛸・・・

Star Destroyer fleet count

Put destroyer count in A1.

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

🛸🛸🛸 Imperial fleet

Rebel starfighter squadron

Put squadron size in A1.

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

⭐⭐⭐🛸🛸🛸

R2-D2 beep meter

Put beep level 0-5 in A1.

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

🤖●●●○○

BB-8 roll distance

Put roll distance 0-10 in A1.

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

🤖●●●●○○○○○○

C-3PO worry level

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

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

🤖🤖🤖 Oh my!

Porg infestation count

Put porg count in A1.

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

🐦🐦🐦 porgs

Baby Yoda soup rating

Put rating 1-5 in A1.

=REPT("🥣",1)&REPT("⭐",A1)&REPT("☆",MAX(0,B1-A1))

🥣⭐⭐⭐☆☆

Mandalorian beskar armor

Put armor plates 0-5 in A1.

=REPT("🛡️",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))

🛡️🛡️🛡️○○

Light side vs dark side meter

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

=REPT("😇",MIN(A1,B1))&REPT("😈",MAX(0,B1-A1))

😇😇😇😈😈

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

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("◎",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" tractor beam"

◎◎◎○○ tractor beam

Imperial loyalty meter

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

=REPT("🔴",MIN(A1,B1))&REPT("⚫",MAX(0,B1-A1))

🔴🔴🔴⚫⚫

Galactic Senate vote tally

Put yes votes in A1 out of 10.

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

👍👍👍👍👎👎👎👎👎👎

Death Star plans recovered

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

=REPT("📜",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" → 🌑"

📜📜📜 → 🌑

Ewok victory celebration

Put celebration level in A1. Confetti and trees.

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

🎉🎉🎉🌲

Vader force choke reach

Put reach distance in A1. Hand to target.

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

✋・・・💀

Wookiee roar volume

Put roar volume in A1. Speaker plus block meter.

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

🔊🔊🔊▁▁

Escape pod launch sequence

Put launch progress 0-10 in A1.

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

・・・・・🚀・・・🪐

Order 66 execution count

Put execution count in A1.

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

⚔️⚔️⚔️ executed

Yoda training patience

Put patience level 1-5 in A1.

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

✨✨✨ ...patience you must have

Han Solo parsecs brag

Put parsecs in A1.

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

12 parsecs🚀🚀🚀

Imperial March footsteps

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

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

🥾🥾🥾 dum dum dum dum

Jabba palace audience

Put audience size in A1.

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

💰💰💰 palace

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

✨✨🚀

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,B1-A1))&"☀️☀️"

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

Obi-Wan vs Vader duel

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

=REPT("⚔️",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))

⚔️⚔️⚔️○○

Yoda lifting the X-Wing

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

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

✨✨✨🚀

Luke's trench approach

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

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

⬛⬛⬛🚀⬛⬛⬛⬛⬛⬛🎯

Death Star charging laser

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

=REPT("🟢",MIN(A1,B1))&REPT("⚪",MAX(0,B1-A1))&" 🌑"

🟢🟢🟢⚪⚪ 🌑

TIE Fighter swarm

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

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

🛸🛸🛸 🚀

X-Wing attack run

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

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

⭐⭐⭐🚀・・・・・

Falcon escaping hyperspace

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

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

✨✨✨🚀💨

Droid factory conveyor

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

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

⚙️⚙️⚙️🤖

Clone army deployed

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

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

🪖🪖🪖 Clone Army

Jedi Council approval

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

=REPT("🟢",MIN(A1,B1))&REPT("⚪",MAX(0,B1-A1))

🟢🟢🟢⚪⚪

Sith influence meter

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

=REPT("🔴",MIN(A1,B1))&REPT("⚫",MAX(0,B1-A1))

🔴🔴🔴⚫⚫

Holocron unlocked

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

=REPT("🔷",MIN(A1,B1))&REPT("⬜",MAX(0,B1-A1))

🔷🔷🔷⬜⬜

Kylo Ren rage level

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

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

💢💢💢○○

Darth Vader breathing

Put breath count in A1. The iconic respirator rhythm.

=REPT("😮‍💨",A1)

😮‍💨😮‍💨😮‍💨

Force ghost appearance

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

=REPT("👻",A1)

👻👻

Ewok trap readiness

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

=REPT("🪵",MIN(A1,B1))&REPT("🌲",MAX(0,B1-A1))

🪵🪵🪵🌲🌲

Speeder bike chase

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

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

🌲🌲🌲🏍️

Jabba's treasure pile

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

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

💰💰💰🐌

Carbonite thaw

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

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

🧊🧊🧊🧊🧊🧊🧊👤

Sarlacc digestion

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

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

🦷🦷🦷🕳️

Boba Fett bounty tracker

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

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

🎯🎯🎯💰

Mandalorian bounty board

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

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

📜📜📜🪙

Grogu snack count

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

=REPT("🥚",A1)

🥚🥚🥚

Jawa scrap haul

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

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

⚙️⚙️⚙️🤎

Sandcrawler inventory

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

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

📦📦📦🚚

Blue milk rating

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

=REPT("🥛",MIN(A1,B1))&REPT("☆",MAX(0,B1-A1))

🥛🥛🥛☆☆

Mos Eisley cantina crowd

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

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

🎺🎺🎺🍺

Cantina band intensity

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

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

🎷🎷🎷🎺🎺

Force push distance

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

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

〰️〰️〰️👤

Jedi meditation

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

=REPT("🧘",A1)

🧘🧘🧘

Lightsaber crystal alignment

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

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

🔵

Bacta tank recovery

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

=REPT("💙",MIN(A1,B1))&REPT("🤍",MAX(0,B1-A1))

💙💙💙🤍🤍

Star Destroyer blockade

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

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

🛸🛸🛸🪐

Shield generator charging

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

=REPT("🛡️",A1)&REPT("⚡",MAX(0,B1-A1))

🛡️🛡️🛡️⚡⚡

Thermal detonator countdown

Put seconds elapsed 0-10 in A1. Countdown to Leia's thermal detonator.

=MAX(0,B1-A1)&" 💣"

7 💣

Holo-message transmission

Put signal strength 0-5 in A1. Leia's distress call beams across space.

=REPT("📡",A1)&"👸"

📡📡📡👸

Rebel transmission strength

Put signal bars 0-5 in A1. Rebel comms punch through Imperial jamming.

=REPT("📶",A1)

📶📶📶

Imperial alert level

Put alert level 1-5 in A1. Death Star goes from green to red alert.

=CHOOSE(A1,"🟢","🟡","🟠","🔴","🚨")

🟠

Force balance

Put light-side score 0-10 in A1. White and black sides of the Force.

=REPT("⚪",A1)&"⚖️"&REPT("⚫",MAX(0,B1-A1))

⚪⚪⚪⚖️⚫⚫⚫⚫⚫⚫⚫

Binary sunset blinking

Animates with NOW(). Twin suns blink on Tatooine. No input needed.

=IF(MOD(NOW()*86400,2)=0,"☀️☀️","🌅")

☀️☀️

R2-D2 beeping

Animates with NOW(). R2 cycles through colored indicator lights.

=CHOOSE(MOD(NOW()*86400,4)+1,"🤖","🤖🔵","🤖🔴","🤖🟢")

🤖🔵

Lightsaber flicker

Animates with NOW(). Blade sparks on and off during the duel.

=IF(MOD(NOW()*86400,2)=0,"⚔️✨","⚔️")

⚔️✨

Death Star charging

Animates with NOW(). Superlaser charge pulses on the Death Star.

=REPT("🟢",MOD(NOW()*86400,6))&"🌑"

🟢🟢🟢🌑

Hyperdrive charging

Animates with NOW(). Falcon hyperdrive motivator spins up.

=REPT("✨",MOD(NOW()*86400,8))&"🚀"

✨✨✨✨🚀

Related formula guides

Go deeper with Better Sheets

Members get full courses on CHAR, REPT, and dashboard design, plus hundreds of Google Sheets tutorials. Copy-paste formulas here stay free.

Unlock playground
Ads keep the free stuff free. Members browse ad-free — log in or see pricing.
Big Year 2027 calendar: the whole year on one Google Sheet

Free 2027 calendar.Plan all of 2027 on one Google Sheet, free.

Copy it to your Google Drive.

Free. No password, no card. The sheet link shows up right here.