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.