Health Bubble Turn Colors when Status is Updated

Hello,

I am new to Smartsheet. I am trying to get when I change my Status to "Not Started" I want the Health bubble to automatically turn grey. And when I change my Status to "In Progress" the Health bubble will turn yellow, etc.

So far I have: IF(Status1 = "Not Started", "Gray", " ").

I want it to change color for each value change. Thanks!

Edit: I figured it out.

Find more posts tagged with

Formulas

Project Management

Accepted answers

Kleerfyre

You will need a nested IF formula:

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

Just add more IF Statements like above for what you need. Put all ) at the very end. Then you can turn it into a column formula by right clicking the cell the formula is in and selecting column formula.

All comments

Kleerfyre

You will need a nested IF formula:

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

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.