Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
HiI want to make a rule, so my health symbol automatically turns green if the status changes to completed. Can anyone help?
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
