Health Bubble Turn Colors when Status is Updated

clairehunter

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.

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.

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.