Google Sheets Lord of the Rings Formulas

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

Fan-inspired sheet art. Not affiliated with or endorsed by Middle-earth Enterprises.

Take Ring to Mordor

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

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

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

REPT MAX

One Ring Mount Doom trek

Put journey progress 0-10 in A1. The ring closes on the volcano.

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

🧝🧙🧔・・・・・👣👣👣

REPT MAX

Shire to Bree journey

Put journey progress 0-10 in A1. Hobbits leave the Shire for the Prancing Pony.

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

🌉🧙🔥🔥🔥👹🔥🔥

REPT MAX

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

・・🏇・・・・・・💍

REPT MAX

Ent march progress

Put march progress 0-6 in A1. Ents advance on the tower.

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

🌳🌳🌳・・・🏰

REPT MAX

Gollum ring obsession meter

Put obsession level 0-5 in A1. Rings fill as Gollum fixates.

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

💍💍💍○○ Gollum

REPT

Sam carrying Frodo bar

Put climb progress 0-10 in A1. Sam carries Frodo up the mountain.

="🧑"&REPT("・",MAX(0,B1-A1))&"🎒🧔"&REPT("・",A1)&"⛰️"

🧑・・・・・🎒🧔・・・⛰️

REPT MAX

Eye of Sauron attention tracker

Put attention level 0-5 in A1. The Eye watches closer.

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

👁️👁️👁️○○ Sauron

REPT

Second breakfast vs eleventies counter

Put meal count 1-3 in A1. First breakfast, second breakfast, or elevenses.

=CHOOSE(MIN(A1,3),"","🍞","🍞🍞","🍞🍞🧇")

🍞🍞🧇

CHOOSE MIN

Palantír vision stages

Put vision stage 1-4 in A1. The seeing-stone reveals more.

=CHOOSE(MIN(A1,4),"○","🔮","🔮🔮","👁️🔮")

👁️🔮

CHOOSE MIN

Rohan horse ride

Put ride progress 0-10 in A1. Riders thunder across the plains.

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

🐴🐴🐴・・・・・🏇

REPT MAX

Anduin river voyage

Put voyage progress 0-10 in A1. The fellowship rows down the great river.

=REPT("・",MAX(0,B1-A1))&"🛶"&REPT("🌊",A1)&"🏔️"

・・・・・🛶🌊🌊🌊🏔️

REPT MAX

Mirkwood spider tension

Put tension level 0-8 in A1. Webs thicken in the dark forest.

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

🌲🌲🌲🕷️🕸️🕸️🕸️

REPT MAX

Related formula guides

Go deeper with Better Sheets

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

See membership options