Newb question regarding Emoji Slider

1

Have been exploring and enjoying my time with Coda, however it’s got me quite frustrated at the moment.

Figured I would try out some puzzles and have been stumped at #1 aka “emoji slider”

To my knowledge I’ve copied the example exactly yet the formula still won’t work…please send help.

codaformulaissue
codaformulaissue911×290 27.5 KB

This is the formula in my table:

=Switch([Emoji Slider], 5,“:sunglasses::sunglasses::sunglasses::sunglasses::sunglasses:”,4,“:slightly_smiling_face::slightly_smiling_face::slightly_smiling_face::slightly_smiling_face:”,3,“:neutral_face::neutral_face::neutral_face:”,2,“:persevere::persevere:”,1,“:scream:”) …however when I copy and paste the formula here for my example, the below formula includes “thisRow”. Where does “thisRow” come from?

=Switch([thisRow.[Emoji Slider]], 5,“:sunglasses::sunglasses::sunglasses::sunglasses::sunglasses:”,4,“:slightly_smiling_face::slightly_smiling_face::slightly_smiling_face::slightly_smiling_face:”,3,“:neutral_face::neutral_face::neutral_face:”,2,“:persevere::persevere:”,1,“:scream:”)

Below is what was provided as one solution, which I’ve copy and pasted while only changing Slider to Emoji Slider…

Switch(Slider, 5,“:sunglasses::sunglasses::sunglasses::sunglasses::sunglasses:”,4,“:slightly_smiling_face::slightly_smiling_face::slightly_smiling_face::slightly_smiling_face:”,3,“:neutral_face::neutral_face::neutral_face:”,2,“:persevere::persevere:”,1,“:scream:”)

2

Don’t put any square brackets around the “emoji slider” chip!

That should do it for you.

1 Like
3

I tried that but it says missing value…

codasliderissue
codasliderissue957×271 26.5 KB

On Coda’s how we did it page it shows square brackets which is why I tried them.

4

When I click in the formula box the first parenthesis is highlighted. Is this a clue?

codaparenthesis
codaparenthesis827×189 14.2 KB

5

Now you need to delete the = sign at the beginning of the formula

You can also complete the challenge a bit more easily by using a Repeat() function

image
image1124×432 31.3 KB

1 Like
6

wow…I knew it was going to be something so simple. Thank Scott, my head is no longer exploding.

scottslider

7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.