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!