I am trying to create a RYG formula
Have a drop down column with the choices:
75% staffing
50% staffing
25% staffing
<25% staffing
I want to say that IF([Staffing Level Impact to MEF]@row = "75% staffing", "Green", IF([Staffing Level Impact to MEF]@row = "50% staffing", "Yellow", IF(OR(([Staffing Level Impact to MEF]@row = "25% staffing", "Red", IF([Staffing Level Impact to MEF]@row = "<25% staffing", "Red", "Gray"))
But no matter what variation of the above I try i get #unparseable.
Help.