nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

RYG Ball & Status, Help needed

Naif AlQazlan

Hi,

I'm trying to create a RYG color based on Status column, I have tried:

Empty or Not started = RED

In Progress = Yellow

Complete = Green

=IF([Status]3 = "Not Started", "Red", IF([Status]3 = "In Progress", Yellow, IF([Status]3 = "Complete", Green)))

=IF(Status3 = "Not Started", "Red", IF(Status3 = "In Progress", Blue, IF(Status3 = "Complete", Green)))

=IF(Status@3 = "In Progress"; "Green"; IF(Status@3 = "Potential Delay"; "Yellow"; IF(Status@3 = "Behind Schedule"; "Red"; IF(Status@3 = "Complete"; "Blue"))))

I always get "Unparseable" am I missing something?

Find more posts tagged with

Accepted answers

Paul Newcome

Try your first one again except put quotes around "Yellow" and "Green".

=IF([Status]3 = "Not Started", "Red", IF([Status]3 = "In Progress", "Yellow", IF([Status]3 = "Complete", "Green")))

All comments

Paul Newcome

Try your first one again except put quotes around "Yellow" and "Green".

=IF([Status]3 = "Not Started", "Red", IF([Status]3 = "In Progress", "Yellow", IF([Status]3 = "Complete", "Green")))

Naif AlQazlan

Many thanks Paul, worked like a Charm.

Paul Newcome

Happy to help! 👍️

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.