Automating R/Y/G/G Formula for some colors

Andrea Mayer
Andrea Mayer ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello - 

Is it possible to create a formula that only looks for some of the colors in the R/Y/G/G drop down column.

My drop down order in the Stage column is Not Started, In Progress, Completed. In my Status column I have Red, Yellow, Green, Gray.

I am looking to create a formula that enters a 'Gray' icon when 'Completed' is selected as status and a 'Green' icon when 'Not Started' is selected. I don't want 'Red' or 'Yellow' to auto pop when 'In Progress is selected. 

I am using this currently and receiving the 'Unparseable' error.

=IF(Stage118 = 0, "Green", (Stage118 = 2, "Gray"))

Is this possible? Any help is appreciated!

Thanks!

Andrea

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!