Google Sheets Gamer Tracker Formulas

Block-game hearts, speedrun timers, and session status rows.

Minecraft heart health row

Put hearts left 0-10 in A1. Full hearts show remaining health; empty hearts show damage taken.

=REPT("❤️",MIN(A1,B1))&REPT("🖤",MAX(0,B1-A1))

❤️❤️❤️❤️❤️🖤🖤🖤🖤🖤

REPT MIN MAX

Speedrun timer row

Put elapsed minutes 0-10 in A1. Stopwatch dots track your run pace.

=REPT("⏱️",1)&REPT("●",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" min"

⏱️●●●●●●○○○○ min

REPT MIN MAX

Garden plot growth

Put growth stage 0-10 in A1. Seed trail fills as your garden plot grows.

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

🌰・・・・🌱🌱🌱🌻

REPT MAX MIN IF

Seed to sprout trail

Put growth progress 0-10 in A1. Dots lead from seed to sprout to bloom.

=REPT("🌰",1)&REPT("・",MAX(0,B1-A1))&REPT("🌱",MIN(A1,B1))

🌰・・・・・🌱🌱🌱

REPT MAX MIN

Coin earn bar

Put coins earned in A1 and coin goal in B1. Gold coins fill the earn bar.

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

🪙🪙🪙🪙🪙○○○○○ 5 coins

REPT MIN MAX

Pet happiness meter

Put happiness 0-5 in A1. Hearts show how happy your virtual pet is.

=REPT("💖",MIN(A1,B1))&REPT("🤍",MAX(0,B1-A1))&" pet mood"

💖💖💖🤍🤍 pet mood

REPT MIN MAX

Minecraft pickaxe durability

Put durability 0-10 in A1. Pickaxes wear down as blocks are mined.

=REPT("⛏️",MIN(A1,B1))&REPT("💔",MAX(0,B1-A1))&" durability"

⛏️⛏️⛏️💔💔💔💔💔💔💔 durability

REPT MIN MAX

Minecraft hunger bar

Put food level 0-10 in A1. Drumsticks fill as hunger is restored.

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

🍗🍗🍗🍗🍗○○○○○ hunger

REPT MIN MAX

Minecraft XP level meter

Put XP progress 0-10 in A1. Orbs fill toward the next level up.

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

✨✨✨✨✨✨○○○○ Lv up

REPT MIN MAX

Minecraft block stack height

Put block count 0-10 in A1. Grass blocks stack into a tower.

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

🟩🟩🟩🟩🟩⬜⬜⬜⬜⬜ blocks

REPT MIN MAX

Creeper distance warning

Put creeper distance 0-10 in A1. Fewer dots means the creeper is closer.

=REPT("💥",IF(A1<=2,1,0))&REPT("🟢",MAX(0,MIN(A1-1,B1)))&REPT("👾",1)&" creeper"

🟢🟢🟢🟢👾 creeper

REPT IF MIN MAX

Controller battery bar

Put battery percent 0-100 in A1. Five blocks show controller charge left.

=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

Respawn countdown row

Put seconds left 0-10 in A1. Dots count down until respawn.

=REPT("⏱️",1)&REPT("●",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" respawn"

⏱️●●●●●○○○○○ respawn

REPT MIN MAX

Achievement unlock percent

Put achievements unlocked in A1 and total in B1. Trophies fill the unlock bar.

=REPT("🏆",MIN(A1,B1))&REPT("🔒",MAX(0,B1-A1))&" "&ROUND(A1/B1*100,0)&"%"

🏆🏆🏆🔒🔒🔒 50%

REPT MIN MAX ROUND

Loot drop rarity bar

Put rarity tier 1-5 in A1. Common through legendary loot colors.

=CHOOSE(A1,"⚪ Common","🟢 Uncommon","🔵 Rare","🟣 Epic","🟠 Legendary")

🟣 Epic

CHOOSE

Boss HP phases bar

Put boss health 0-10 in A1. Skull marks each phase as HP drops.

=REPT("❤️",MIN(A1,B1))&REPT("💀",MAX(0,B1-A1))&" 👹 boss"

❤️❤️❤️💀💀💀💀💀💀💀 👹 boss

REPT MIN MAX

Multiplayer ping mood

Put ping ms in A1. Green under 50, yellow under 100, red above.

=IF(A1<=50,"🟢 Lag-free","🟡 OK")&IF(A1>100," 🔴 High ping","")&" "&A1&"ms"

🟢 Lag-free 32ms

Game lives counter

Put lives left 0-3 in A1. Controllers show remaining lives.

=REPT("🎮",MIN(A1,B1))&REPT("💀",MAX(0,B1-A1))&" lives"

🎮🎮💀 lives

REPT MIN MAX

Level up burst row

Put levels gained 0-5 in A1. Stars burst when you level up.

=IF(A1>0,REPT("⭐",MIN(A1,5))&" Level up!","")

⭐⭐⭐ Level up!

IF REPT MIN

Roblox avatar mood

Put mood score 1-5 in A1. Face emoji tracks your avatar vibe.

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

😄

CHOOSE

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