Google Sheets Fantasy Tracker Formulas

Helm's Deep battle line

Put defense strength 0-10 in A1. Shields and arrows hold the wall.

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

🛡️🛡️🛡️🏹🏹🏹🏹 🏰

REPT MAX

Rohan cavalry charge

Put charge progress 0-10 in A1. Riders thunder toward the battle.

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

🐴🐴🐴・・・・・⚔️

REPT MAX

Orc army counter

Put orc count 0-5 in A1.

=REPT("👹",MIN(A1,B1))&REPT("○",MAX(0,B1-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("🏹",MIN(A1,B1))&REPT("○",MAX(0,B1-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,B1-A1))&"🦅"&REPT("・",A1)&"⛰️"

・・・・・🦅・・・⛰️

REPT MAX

Sauron eye gaze intensity

Put gaze level 0-5 in A1.

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

👁️👁️👁️○○

REPT

Palantir vision meter

Put visions seen 0-5 in A1.

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

🔮🔮🔮○○

REPT

Mithril armor plates

Put armor plates 0-5 in A1.

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

🛡️🛡️🛡️○○ mithril

REPT

Shelob web trap progress

Put web density 0-8 in A1. Spider closes in the tunnel.

=REPT("🕸️",A1)&REPT("・",MAX(0,B1-A1))&"🕷️"

🕸️🕸️🕸️・・・🕷️

REPT MAX

Mines of Moria depth

Put depth level 0-10 in A1. Deeper into the dark mines.

=REPT("⛏️",MIN(A1,B1))&REPT("・",MAX(0,B1-A1))&"💀"

⛏️⛏️⛏️・・・・・💀

REPT MAX

Cave troll encounter

Put troll threat 0-5 in A1.

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

👹👹👹○○ troll

REPT

Elven star light rating

Put elven rating 0-5 in A1.

=REPT("✨",MIN(A1,B1))&REPT("☆",MAX(0,B1-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,B1-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("🔥",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&"🐉"

🔥🔥🔥○○🐉

REPT

Sword fight intensity

Put duel level 0-5 in A1.

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

⚔️⚔️⚔️○○

REPT

Castle siege progress

Put siege progress 0-10 in A1. Arrows rain on the castle.

=REPT("🏹",MIN(A1,B1))&REPT("・",MAX(0,B1-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("💀",MIN(A1,B1))&REPT("○",MAX(0,B1-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("🦄",MIN(A1,B1))&REPT("🌸",MAX(0,B1-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("🦇",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))

🦇🦇🦇○○

REPT

Medusa stone gaze

Put gaze level 0-3 in A1. Victims turn to stone.

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

🐍🐍👁️🪨

REPT MAX

Potion brewing progress

Put brew progress 0-5 in A1. Vials fill toward the finished potion.

=REPT("🧪",A1)&REPT(CHAR(9617),MAX(0,B1-A1))&" 🧙"

🧪🧪🧪▒▒ 🧙

REPT CHAR

Spell casting power

Put mana level 0-5 in A1.

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

✨✨✨○○ mana

REPT

Enchanted forest path

Put path progress 0-5 in A1. Trees and fairies line the trail.

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

🌲🌲🌲✨✨🧚

REPT MAX

Wizard tower ascent

Put climb progress 0-10 in A1. Wizard climbs toward the tower top.

=REPT("・",MAX(0,B1-A1))&"🧙"&REPT("・",A1)&"🗼"

・・・・・🧙・・・🗼

REPT MAX

Quest scroll tracker

Put quests completed 0-3 in A1.

=REPT("📜",MIN(A1,B1))&REPT("○",MAX(0,B1-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("🪓",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))

🪓🪓🪓○○

REPT

Shield wall formation

Put shield count 0-5 in A1.

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

🛡️🛡️🛡️○○

REPT

War camp fire intensity

Put campfire level in A1. Tents ring the flames.

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

⛺⛺⛺🔥🔥

REPT MAX

Elven vs orc battle meter

Put elven strength 0-5 in A1. Elves push back the orcs.

=REPT("🧝",MIN(A1,B1))&REPT("👹",MAX(0,B1-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("🧜",MIN(A1,B1))&REPT("🌊",MAX(0,B1-A1))

🧜🧜🧜🌊🌊

REPT

Kraken tentacle attack

Put tentacle count in A1. Tentacles rise from the deep.

=REPT("🐙",A1)&REPT("🌊",MAX(0,B1-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,B1-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,B1-A1))

🧚✨✨✨✨・・・・・

REPT MAX

Excalibur drawn from the stone

Put pull strength 0-10 in A1. Sword rises from the stone.

=REPT("🪨",MAX(0,B1-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("⛏️",MIN(A1,B1))&REPT("💰",MAX(0,B1-A1))

⛏️⛏️⛏️💰💰💰💰💰💰💰

REPT MAX

Magic portal opening

Put portal power 0-5 in A1.

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

🌀🌀🌀○○

REPT

Necromancer army raised

Put skeleton count 0-5 in A1.

=REPT("💀",A1)&REPT("⚰️",MAX(0,B1-A1))

💀💀💀⚰️⚰️

REPT MAX

Dark tower corruption

Put corruption level 0-5 in A1.

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

⚫⚫⚫⚪⚪ 🏰

REPT

Wizard spellbook mastery

Put spells learned 0-10 in A1.

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

📖📖📖✨✨✨✨✨✨✨

REPT MAX

Magic wand charge

Put charge level 0-5 in A1.

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

✨✨✨⚪⚪🪄

REPT

Crystal ball clarity

Put vision strength 0-5 in A1.

=REPT("🔮",MIN(A1,B1))&REPT("🌫️",MAX(0,B1-A1))

🔮🔮🔮🌫️🌫️

REPT

Treasure map completion

Put clues found 0-5 in A1.

=REPT("🗺️",MIN(A1,B1))&REPT("❓",MAX(0,B1-A1))

🗺️🗺️🗺️❓❓

REPT

Mimic suspicion level

Put suspicion 0-5 in A1.

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

📦📦📦😈😈

REPT MAX

Bard inspiration meter

Put inspiration 0-5 in A1.

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

🎵🎵🎵○○

REPT

Tavern quest rumors

Put rumors heard 0-5 in A1.

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

🍺🍺🍺📜📜

REPT MAX

Rogue stealth level

Put stealth level 0-5 in A1.

=REPT("🗡️",MIN(A1,B1))&REPT("🌑",MAX(0,B1-A1))

🗡️🗡️🗡️🌑🌑

REPT

Ranger tracking progress

Put tracks found 0-10 in A1.

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

👣👣👣🌲🌲🌲🌲🌲🌲🌲

REPT MAX

Enchanted sword power

Put enchantment level 0-5 in A1.

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

⚔️⚔️⚔️✨✨

REPT MAX

Dragon egg hatch progress

Put hatch progress 0-10 in A1.

=REPT("🥚",MAX(0,B1-A1))&"🐣"&REPT("🔥",A1)

🥚🥚🥚🥚🐣🔥🔥🔥🔥🔥🔥

REPT MAX

Pegasus flight distance

Put flight progress 0-10 in A1.

=REPT("☁️",A1)&"🦄"&REPT("☁️",MAX(0,B1-A1))

☁️☁️☁️🦄☁️☁️☁️☁️☁️☁️☁️

REPT MAX

Treasure chest lockpick

Put lockpick progress 0-5 in A1.

=REPT("🗝️",MIN(A1,B1))&REPT("🔒",MAX(0,B1-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("😇",MIN(A1,B1))&REPT("😈",MAX(0,B1-A1))

😇😇😇😈😈

REPT

Quest completion tracker

Put quests completed 0-10 in A1.

=REPT("✅",MIN(A1,B1))&REPT("📜",MAX(0,B1-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("❤️",MIN(A1,B1))&REPT("🖤",MAX(0,B1-A1))&" 👹"

❤️❤️❤️❤️🖤🖤🖤🖤🖤🖤 👹

REPT

Helm's Deep battle line

Rohan cavalry charge

Orc army counter

Uruk-hai squad size

Legolas arrow volley

Gimli axe kill count

Ent march on Isengard

Great Eagles rescue flight

Sauron eye gaze intensity

Palantir vision meter

Mithril armor plates

Shelob web trap progress

Mines of Moria depth

Cave troll encounter

Elven star light rating

Knight vs dragon duel

Dragon treasure hoard

Dragon fire breath meter

Sword fight intensity

Castle siege progress

Goblin ambush counter

Skeleton army march

Troll bridge toll

Unicorn meadow count

Griffin mountain flight

Phoenix rebirth flames

Hydra head count

Werewolf moon howl

Vampire bat swarm

Medusa stone gaze

Potion brewing progress

Spell casting power

Enchanted forest path

Wizard tower ascent

Quest scroll tracker

Tavern ale rating

Treasure chest loot count

Battle axe squad

Shield wall formation

War camp fire intensity

Elven vs orc battle meter

Hero or villain alignment

Fantasy weapon picker

Dragon slayer victory

Mermaid lagoon count

Kraken tentacle attack

Cyclops boulder throw

Fairy dust sparkle trail

Excalibur drawn from the stone

King Arthur's round table

Dwarf gold mine

Magic portal opening

Necromancer army raised

Dark tower corruption

Wizard spellbook mastery

Magic wand charge

Crystal ball clarity

Treasure map completion

Mimic suspicion level

Bard inspiration meter

Tavern quest rumors

Rogue stealth level

Ranger tracking progress

Enchanted sword power

Dragon egg hatch progress

Pegasus flight distance

Treasure chest lockpick

Magic academy grades

Alignment meter

Quest completion tracker

Loot rarity picker

Boss battle health bar

Related formula guides

Go deeper with Better Sheets