IF formula return RYG symbol based on Status

Hello - I am very new to Smartsheet and am trying to write what I think is a simple formula, but I keep getting an Incorrect Argument error. This is what I need:

If Status = In progress, green ball

If Status = On Hold, red ball

If Status = Complete, grey ball

If Status = Not Started, yellow ball

Find more posts tagged with

Accepted answers

David Joyeuse

Hi @Donna Newton

That should be something like:

=IF([Status]@row = "In Progress", "Green", IF([Status]@row = "On Hold", "Red", IF([Status]@row = "Complete", "Grey", "Yellow")))

Hope it helped!

All comments

David Joyeuse

Hi @Donna Newton

That should be something like:

=IF([Status]@row = "In Progress", "Green", IF([Status]@row = "On Hold", "Red", IF([Status]@row = "Complete", "Grey", "Yellow")))

Hope it helped!

Donna Newton

Hi @David Joyeuse That was exactly what I needed - I just had to change "grey" to "gray" and it worked perfectly. Thank you!!!

Donna Newton

Follow up comment - What I was doing wrong was trying to write an IF to return the Yellow, instead of leaving the Yellow as the item to return if the first three weren't selected. Light bulb moment!

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.