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

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

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

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!

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

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

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

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

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

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! ✨

IF

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

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

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

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

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

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

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

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

IF

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

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

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!

IF

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

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

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

Capture streak counter

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

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

🎯🎯🎯🎯 4 streak

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

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.