Symbols Question
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(Status@row = “Blocked”, "Red", IF(Status@row = “Closed”, “Grey”, IF(OR(Status@row = “To Do“, Status@row = “Working”, Status@row = “Release Pending“, Status@row = “Testing”), “Green”)))
Amy
Answers
-
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.
-
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(Status@row = "Blocked", "Red", IF(Status@row = "Closed", "Gray", IF(OR(Status@row = "To Do", Status@row = "Working", Status@row = "Release Pending", Status@row = "Testing"), "Green")))
You don't need to include any of the status color options to make the formula parseable.
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
Paul - I did replace the quotes and re-typed the formula and it did not work.
=IF(Status@row = "Blocked", "Red", IF(Status@row = "Closed", "Grey", IF(OR(Status@row = "To Do", Status@row = "Working", Status@row = "Release Pending", Status@row = "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
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!