Getting #unparseable using multiple IF function

Hello Smartsheet community,

I have been trying to resolve my error by looking online and this forum, but still can't fix my error. I'm hoping you smart experts can help me. I have 2 columns: Completion Status and Status. The Completion Status has 4 choices: Not Started, In Progress, Delayed, and Complete. The Status has 4 color balls: Blue, Green, Yellow and Red.

Here are the correlation I want:

Complete = Blue, Not Started = Blank, In Progress = Green, Delayed = Yellow, and At Risk = Red**

** Not shown in the screenshot is another column called At Risk with a flag. If something is at risk, then the flag would be checked. I want the status ball to be red when that flag is checked.

Any help you all can provide be would be appreciated. Thank you.

Find more posts tagged with

Accepted answers

Paul Newcome

An additional IF statement at the beginning should work for you.

=IF([At Risk]@row = 1, "Red", IF(.............................................................

Paul Newcome

Happy to help! 👍️

That is because IF statements read left to right and stop at the first true value. So if any of the IF's before it were true, it would have never been evaluated for the last one.

All comments

Paul Newcome

Try removing the closing parenthesis from after "Blue".

Nathan Nguyen

@Paul Newcome That worked. Do you know how I should structure the logic for the red status when I click on the AT Risk flag? Thanks.

Paul Newcome

An additional IF statement at the beginning should work for you.

=IF([At Risk]@row = 1, "Red", IF(.............................................................

Nathan Nguyen

@Paul Newcome Thank you, it worked! Appreciate the help. 😀. Oddly, I tried putting the red logic at the end and didn't work, but it worked after putting it in the front like you said

Paul Newcome

Happy to help! 👍️

That is because IF statements read left to right and stop at the first true value. So if any of the IF's before it were true, it would have never been evaluated for the last one.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.