Google Sheets Pokemon Tracker Formulas

Collection percent, type badges, and party status for dex tracking.

Collection completion percent bar

Put creatures caught in A1 and total in B1. Filled circles track collection percent.

=REPT("◉",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("○",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" "&ROUND(A1/B1*100,0)&"% caught"

◉◉◉◉◉◉◉○○○ 68% caught

REPT ROUND MIN MAX

Dex fill bar

Put entries logged in A1 and dex size in B1. Blocks fill your creature index.

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

███████░░░ dex

REPT ROUND MIN MAX

Shiny luck stars

Put shiny luck 0-5 in A1. Sparkle stars rate your rare find odds.

=REPT("✨",MIN(A1,5))&REPT("☆",MAX(0,5-A1))&" shiny luck"

✨✨✨☆☆ shiny luck

REPT MIN MAX

Type advantage status

Put matchup 1-3 in A1. Super effective, normal, or not very effective label.

=CHOOSE(A1,"💥 Super effective!","✅ Normal","🛡️ Not very effective...")

💥 Super effective!

CHOOSE

Creature type picker

Put type 1-5 in A1. Fire, water, grass, electric, or rock type emoji.

=CHOOSE(A1,"🔥 Fire","💧 Water","🌿 Grass","⚡ Electric","🪨 Rock")

⚡ Electric

CHOOSE

HP bar project health

Put HP 0-5 in A1. Hearts show project or task health remaining.

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

❤️❤️❤️🖤🖤 HP

REPT MIN MAX

Power level rating

Put power level 0-5 in A1. Lightning bolts rate creature or project strength.

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

⚡⚡⚡⚡○ power 4

REPT MIN MAX

Evolution stage progress

Put stage 1-3 in A1. Egg, hatchling, or evolved form label.

=CHOOSE(A1,"🥚 Stage 1","🐣 Stage 2","🦅 Stage 3")

🐣 Stage 2

CHOOSE

Gym badge counter

Put badges earned 0-8 in A1. Medal icons count gym victories.

=REPT("🏅",MIN(A1,8))&" "&A1&"/8 badges"

🏅🏅🏅🏅 4/8 badges

REPT MIN

Rare catch celebration

Put 1 if rare catch or 0 if still hunting. Shiny find celebration.

=IF(A1=1,"🌟 Shiny caught! ✨","🔍 Still hunting...")

🌟 Shiny caught! ✨

Team lineup creature picker

Put slot 1-5 in A1. Picks a fan-inspired creature for your team row.

=CHOOSE(A1,"🔥 Ember fox","💧 Aqua fin","🌿 Leaf sprite","⚡ Volt hare","🪨 Boulder pup")

💧 Aqua fin

CHOOSE

Battle win loss streak

Put wins in A1 and losses in B1. Trophies vs broken hearts show battle record.

=REPT("🏆",MIN(A1,5))&REPT("💔",MIN(B1,5))&" "&A1&"W-"&B1&"L"

🏆🏆🏆💔💔 3W-2L

REPT MIN

XP to next level bar

Put current XP in A1 and XP needed in B1. Stars fill toward next level.

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

⭐⭐⭐⭐⭐⭐⭐○○○ 7 XP

REPT MIN MAX

Task ailment status

Put status 1-5 in A1. Ready, asleep, paralyzed, burned, or frozen task label.

=CHOOSE(A1,"✅ Ready","😴 Asleep","⚡ Paralyzed","🔥 Burned","❄️ Frozen")

⚡ Paralyzed

CHOOSE

Wild encounter CRM status

Put stage 1-4 in A1. Wild lead, throwing ball, caught, or fled pipeline.

=CHOOSE(A1,"👀 Wild encounter","🎯 Throwing ball","✅ Caught!","🏃 Fled")

🎯 Throwing ball

CHOOSE

Lead caught evolved CRM

Put CRM stage 1-4 in A1. Gamified sales: wild lead, caught, evolved, champion.

=CHOOSE(A1,"👀 Wild lead","✅ Caught","✨ Evolved","🏆 Champion")

✨ Evolved

CHOOSE

Starter creature picker

Put starter 1-3 in A1. Flame, wave, or vine starter choice.

=CHOOSE(A1,"🔥 Flame starter","💧 Wave starter","🌿 Vine starter")

🔥 Flame starter

CHOOSE

Level up burst

Put current level XP in A1 and XP to level in B1. Celebration when threshold hit.

=IF(A1>=B1,"🎉 Level up! Lv"&A1,"Lv "&A1&" ("&A1&"/"&B1&" XP)")

🎉 Level up! Lv12

Trainer journey to gym

Put steps taken in A1 and gym distance in B1. Walker icons march toward the arena.

=REPT("🚶",MIN(A1,B1))&"🏟️"&REPT("・",MAX(0,B1-A1))

🚶🚶🚶🚶🚶🏟️・・・・・

REPT MIN MAX

Rare ball ready status

Put 1 if rare ball equipped or 0 for standard. Premium catch attempt flag.

=IF(A1=1,"🔴 Rare ball ready!","⚪ Standard ball")

🔴 Rare ball ready!

Potion heal counter

Put potions remaining 0-5 in A1. Vials track heals left for blocked tasks.

=REPT("🧪",MIN(A1,5))&" heals left"

🧪🧪🧪 heals left

REPT MIN

Type matchup advantage picker

Put matchup 1-5 in A1. Type triangle advantage label with emoji types.

=CHOOSE(A1,"🔥>🌿 Fire beats grass","💧>🔥 Water beats fire","🌿>💧 Grass beats water","⚡>💧 Electric beats water","🪨>🔥 Rock beats fire")

💧>🔥 Water beats fire

CHOOSE

Creature collection milestone

Put total caught in A1. Star bursts mark each 10-creature milestone.

=REPT("🌟",MIN(10,MAX(0,ROUND(A1/10,0))))&" "&A1&" caught"

🌟🌟🌟🌟🌟 52 caught

REPT MIN MAX ROUND

Capture streak counter

Put consecutive catches in A1. Ball icons stack your hot capture streak.

=REPT("🎯",MIN(A1,5))&" "&A1&" streak"

🎯🎯🎯🎯 4 streak

REPT MIN

Creature happiness mood

Put happiness 1-5 in A1. Faces show how content your tracked creature feels.

=CHOOSE(A1,"😍 Ecstatic","😊 Happy","😐 Neutral","😟 Grumpy","😴 Resting")

😊 Happy

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