Health Formula

In my task sheet health column I am trying to write a formula that I desperately need help with. I have a column labeled status. It is a drop down column where I can select "Not Started", "In Progress", or "Complete". I would like my health column to reflect a color based on the input in the status column. Green if it is "Complete", yellow if it is "In Progress", red if "Not Started".

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try this:

=IF(Status@row = "Not Started", "Red", IF(Status@row = "In Progress", "Yellow", "Green"))

All comments

Paul Newcome

Try this:

=IF(Status@row = "Not Started", "Red", IF(Status@row = "In Progress", "Yellow", "Green"))

Kelsey L DeOrdio

@Paul Newcome Thank you so much!

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