Archived 2017 Posts
Archived 2017 Posts
Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
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?
Tags:
Comments
-
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
This discussion has been closed.