Skip to content
Puzzle #1: The emoji slider
😍 Puzzle #1: The emoji slider
Puzzle Solution
More
Share
Explore
Puzzle Solution

icon picker
How we did it

The solution, step-by-step
⁠
Loading…
⁠
⁠
The most common solution is with Switch():
Switch(Slider, 5,"😎😎😎😎😎",4,"🙂🙂🙂🙂",3,"😐😐😐",2,"😣😣",1,"😱")
Similarly, you can use SwitchIf():
SwitchIf(Slider=5,"😎😎😎😎😎",Slider=4,"🙂🙂🙂🙂",Slider=3,"😐😐😐",Slider=2,"😣😣",Slider=1,"😱")
If you missed Switch and SwitchIF (or if you’re just sadistically addicted to matching parentheses), you can also solve this by nesting lots of If() statements, like so:
If(Slider=5,"😎😎😎😎😎", IF(Slider=4,"🙂🙂🙂🙂", IF(Slider=3,"😐😐😐", IF(Slider=2,"😣😣", IF(Slider=1,"😱", "")))))
A fair number of you used the Repeat() function (which honestly, I forgot that we had):
Switch(Slider, 5,Repeat("😎", Slider), 4, Repeat("🙂", Slider), 3, Repeat("😐", Slider), 2, Repeat("😣", Slider), 1, Repeat("😱", Slider))
Some people wanted to look up the emojis, and we saw a couple patterns for that. One group used List() like this:
List("😎", "🙂", "😐", "😣", "😱").Nth(Slider).Repeat(Slider)
And the other group created a table of emojis, and used the Lookup() formula. Very elegant:
EmojiTable.Lookup(Value, Slider)
Btw, one puzzler had a particularly genius use-case for this. He made a team morale gauge — where each team member can qualify their feelings from yucky (💩) to ecstatic (🏄‍).


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.