Need help with Health Status Formula

I have a sheet with 3 columns: Action, Status, Health

I want the health to populate a green, red, yellow, or gray circle depending on which status the action is in. The status and corresponding health colors are:

Blank = Red

Not Started = Red

In progress = Yellow

Completed = Green

Cancelled = Gray

On Hold = Gray

Looking for a formula that allows all of the above to be true!

Thanks so so much!

Find more posts tagged with

Formulas

Accepted answers

All comments

Nic Larsen

=IF([Status]@row = "Completed", "Green", IF([Status]@row = "In progress", "Yellow", IF(OR([Status]@row = "Cancelled", [Status]@row = "On Hold"), "Gray", "Red")))

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