Symbols Question

07/31/20
Answered - Pending Review

Hello,

I'm receiving an "Unparseable" error on the below. I have a column where I selected symbols to display different statuses. I selected the colored circles where it is Green, Yellow, Red and Grey. Is this issue because I didn't apply the Yellow?

=IF([email protected] = “Blocked”, "Red", IF([email protected] = “Closed”, “Grey”, IF(OR([email protected] = “To Do“, [email protected] = “Working”, [email protected] = “Release Pending“, [email protected] = “Testing”), “Green”)))


Amy

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    The issue is because you are using "smart quotes". See how most of them are slanted to show open vs closed? Those come from programs such as Microsoft Word. You need "non-smart quotes" which are straight up and down such as the ones in this comment and the ones you have around "Red". Try retyping the formula directly into your sheet and see if that clears it up.

    thinkspi.com

  • SoS | Dan PalencharSoS | Dan Palenchar ✭✭✭✭✭
    edited 07/31/20

    Can you share a screenshot of your Sheet? As written, your "Status" column should be a dropdown list with Blocked, To Do, Working, Release Pending, and Testing as selectable options, and whatever column you have that formula in would be the symbol column.

    It looks like this, formula below. Access published sheet at https://app.smartsheet.com/b/publish?EQBCT=40181307242e43158d742249f2f455eb.


    =IF([email protected] = "Blocked", "Red", IF([email protected] = "Closed", "Gray", IF(OR([email protected] = "To Do", [email protected] = "Working", [email protected] = "Release Pending", [email protected] = "Testing"), "Green")))

    You don't need to include any of the status color options to make the formula parseable.

  • Paul - I did replace the quotes and re-typed the formula and it did not work.

    =IF([email protected] = "Blocked", "Red", IF([email protected] = "Closed", "Grey", IF(OR([email protected] = "To Do", [email protected] = "Working", [email protected] = "Release Pending", [email protected] = "Testing"), "Green"))))


    Dan --

    Here is my Status Drop-Down.


    Here is the column with the symbols I selected and where the formula should reside.


    Any idea what I'm doing incorrectly?


    Amy

  • FIXED! I had an extra ending parentheses!


    Amy

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    edited 07/31/20

    Now you have one too many closing parenthesis on the end. Try removing one of them.


    Didn't see your post until after mine. Haha. Yup. That's it.

    thinkspi.com

Sign In or Register to comment.