At Risk column symbol formatting based on status of another column help

Brandon R
Brandon R ✭✭
edited 10/11/23 in Formulas and Functions

I'm trying to have my At Risk column automatically assign a colored symbol based off selected status in a Status column. This is my current formula I built off other users post:

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

I'm getting the #UNPARSEABLE error after hitting enter. I am VERY new to SS and could really use some help. Thanks in advance!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!