Invalid Operation

I am trying to have stoplights populate based off of the data entered in certain columns. I have double checked that the column is set up with the spotlight formatting, but for some reason I am getting the below error still. It is working for Green, but all the other colors are giving me an error. See below.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!