set health based on multiple status columns

Hello! I appreciate your help!

I would like to have a health column that is based on the status columns. For example, if three of the tasks are in progress, but one is delayed, I want the health column to be yellow to show a risk. Is this possible or does the symbol need to be based on input from a single cell?

Thank you!

Find more posts tagged with

Accepted answers

All comments

Joe White

Use conditional formatting. It has the flexibility to do what you're trying to do.

Jillian Cadorette

That's a smart idea.

Jillian Cadorette

One of the reasons that I wanted to have a health column is to make is easy for reporting out.

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.