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

Find more posts tagged with

Accepted answers

All comments

Paul 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.

SoS | Dan Palenchar

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.

Amy Evans

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

Amy Evans

FIXED! I had an extra ending parentheses!

Amy

Paul Newcome

~~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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.