Google Sheets Random Picker Formulas

Dice face

Put 1-6 in A1 for a dice face.

=CHOOSE(A1,"⚀","⚁","⚂","⚃","⚄","⚅")

⚂

CHOOSE

Zodiac sign picker

Put a birthday date in A1. Returns the zodiac sign symbol.

=CHOOSE(LOOKUP(MONTH(A1)*100+DAY(A1),{101,120,219,321,420,521,621,723,823,923,1023,1122,1222},{1,2,3,4,5,6,7,8,9,10,11,12,1}),"♑","♒","♓","♈","♉","♊","♋","♌","♍","♎","♏","♐")

♋

CHOOSE LOOKUP MONTH DAY

Random six-sided dice

Rolls a random dice face 1-6. Recalculates when the sheet updates.

=CHOOSE(RANDBETWEEN(1,6),"⚀","⚁","⚂","⚃","⚄","⚅")

⚂

CHOOSE RANDBETWEEN

Dice face by name

Put one, two, three, four, five, or six in A1 for a dice face.

=SWITCH(LOWER(A1),"one","⚀","two","⚁","three","⚂","four","⚃","five","⚄","six","⚅")

⚂

SWITCH LOWER

Arrow compass

Put direction 1-8 in A1. Clockwise from north.

=CHOOSE(A1,"↑","↗","→","↘","↓","↙","←","↖")

→

CHOOSE

Compass direction arrows

Put a direction in A1: North, South, East, West, or diagonals like North East.

=SWITCH(A1,"North",CHAR(8593),"North East",CHAR(8599),"East",CHAR(8594),"South East",CHAR(8600),"South",CHAR(8595),"South West",CHAR(8601),"West",CHAR(8592),"North West",CHAR(8598))

North → ↑

SWITCH CHAR

Chess rank badge

Put rank 1-6 in A1: pawn through king.

=CHOOSE(A1,CHAR(9823),CHAR(9822),CHAR(9821),CHAR(9820),CHAR(9819),CHAR(9818))

♛

CHOOSE CHAR

Playing card suit

Put 1-4 in A1 for spade, heart, diamond, or club.

=CHOOSE(A1,CHAR(9824),CHAR(9829),CHAR(9830),CHAR(9827))

♠

CHOOSE CHAR

Random card suit

Picks a random spade, heart, diamond, or club. Recalculates when the sheet updates.

=CHOOSE(RANDBETWEEN(1,4),CHAR(9824),CHAR(9829),CHAR(9830),CHAR(9827))

♠

CHOOSE CHAR RANDBETWEEN

Pick a card, any card

Draws one random card from a standard 52-card deck. Recalculates when the sheet updates.

=CHOOSE(RANDBETWEEN(1,13),"A","2","3","4","5","6","7","8","9","10","J","Q","K")&CHOOSE(RANDBETWEEN(1,4),CHAR(9824),CHAR(9829),CHAR(9830),CHAR(9827))

7♠

CHOOSE CHAR RANDBETWEEN

Moon phase picker

Put phase 1-8 in A1 for the lunar cycle.

=CHOOSE(A1,"🌑","🌒","🌓","🌔","🌕","🌖","🌗","🌘")

🌓

CHOOSE

Moon phase by name

Put a phase name in A1: new, waxing crescent, first quarter, waxing gibbous, full, waning gibbous, last quarter, or waning crescent.

=SWITCH(LOWER(A1),"new","🌑","waxing crescent","🌒","first quarter","🌓","waxing gibbous","🌔","full","🌕","waning gibbous","🌖","last quarter","🌗","waning crescent","🌘","🌑")

🌕

SWITCH LOWER

Dragon hatching

Put stage 1-4 in A1. Egg cracks into a full dragon.

=CHOOSE(A1,"🥚","🐣","🐲","🐉")

🐲

CHOOSE

Random season

Picks a random spring, summer, fall, or winter emoji. Recalculates when the sheet updates.

=CHOOSE(RANDBETWEEN(1,4),"🌸","☀️","🍂","❄️")

🍂

CHOOSE RANDBETWEEN

Reaction face picker

Put reaction 1-3 in A1. 1 is stern, 2 is shrug, 3 is cool.

=CHOOSE(A1,"ಠ_ಠ","¯\_(ツ)_/¯","(▀̿Ĺ̯▀̿ ̿)")

¯\_(ツ)_/¯

CHOOSE

Random reaction face

Picks a random stern, shrug, or cool reaction face. Recalculates when the sheet updates.

=CHOOSE(RANDBETWEEN(1,3),"ಠ_ಠ","¯\_(ツ)_/¯","(▀̿Ĺ̯▀̿ ̿)")

¯\_(ツ)_/¯

CHOOSE RANDBETWEEN

Reaction face by name

Put stern, shrug, or cool in A1. Anything else shows shrug.

=SWITCH(LOWER(A1),"stern","ಠ_ಠ","shrug","¯\_(ツ)_/¯","cool","(▀̿Ĺ̯▀̿ ̿)","¯\_(ツ)_/¯")

ಠ_ಠ

SWITCH LOWER

Kaomoji outrage picker

Put mood 1-4 in A1. Table flip, rage flip, bear, or hug.

=CHOOSE(A1,"(╯°□°)╯︵ ┻━┻","(ノಠ益ಠ)ノ彡┻━┻","ʕ•ᴥ•ʔ","(づ｡◕‿‿◕｡)づ")

(╯°□°)╯︵ ┻━┻

CHOOSE

Planet picker

Put planet 1-8 in A1. Mercury through Neptune.

=CHOOSE(A1,"☿️","♀️","🌍","♂️","♃","♄","♅","♆")

🌍

CHOOSE

Random planet picker

Picks a random planet name or emoji. Earth, Saturn, and Neptune use emoji; the rest are words. Recalculates when the sheet updates.

=CHOOSE(RANDBETWEEN(1,8),"Mercury","Venus","🌎","Mars","Jupiter","🪐","Uranus","🔵")

🌎

CHOOSE RANDBETWEEN

Random zodiac sign

Picks a random zodiac sign symbol. Recalculates when the sheet updates.

=CHOOSE(RANDBETWEEN(1,12),"♑","♒","♓","♈","♉","♊","♋","♌","♍","♎","♏","♐")

♋

CHOOSE RANDBETWEEN