How to make a different rul???

Hi
I want to make a rule, so my health symbol automatically turns green if the status changes to completed. Can anyone help?

Find more posts tagged with

Formulas

Hi Kira,

You'll want to create an IF formula in your health symbol column for this.

NOTE: Don't copy and paste these formulas into your sheet, you'll want to manually type these formulas and use your sheet's column names.

Here's an example:

=IF(Status1 = "Completed", "Green")

You can nest IF statements if you want to have the formula change to different symbols based on various statuses:

=IF(Status1 = "Completed", "Green", IF(Status1 = "In Progress", "Yellow", IF(Status1 = "Not Started", "Red")))

More information on functions is available in our Help Center: https://help.smartsheet.com/articles/775363-using-formulas#if