need help with formula

tcanelli41471

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.

Andrée Starå

Hi,

Try something like this.

=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"; [Staffing Level Impact to MEF]@row = "<25% staffing"); "Red"; "Gray")))

The same version but with the below changes for your and others convenience.

=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", [Staffing Level Impact to MEF]@row = "<25% staffing"), "Red", "Gray")))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

tcanelli41471

I had to use decimals, but still not working 100%. Here is what I have so far:

=IF([Minimum Level of Staffing Needed to Perform MEF]@row = 0.75, "Green", IF([Minimum Level of Staffing Needed to Perform MEF]@row = 0.5, "Yellow", IF([Minimum Level of Staffing Needed to Perform MEF]@row < 0.5, "Red", IF([Minimum Level of Staffing Needed to Perform MEF]@row < 0.25, "Red", "Gray"))))

75% shows green

50% shows yellow

but empty cells show red (not gray) - I want this to be gray

25% shows res

and <25% shows gray - I want this to be red

Andrée Starå

Ok.

Try this.

=IF(ISBLANK([Minimum Level of Staffing Needed to Perform MEF]@row); "Gray"; IF([Minimum Level of Staffing Needed to Perform MEF]@row = 0,75; "Green"; IF([Minimum Level of Staffing Needed to Perform MEF]@row = 0,5; "Yellow"; IF([Minimum Level of Staffing Needed to Perform MEF]@row < 0,5; "Red"; IF([Minimum Level of Staffing Needed to Perform MEF]@row < 0,25; "Red"; "Gray")))))

The same version but with the below changes for your and others convenience.

=IF(ISBLANK([Minimum Level of Staffing Needed to Perform MEF]@row), "Gray", IF([Minimum Level of Staffing Needed to Perform MEF]@row = 0.75, "Green", IF([Minimum Level of Staffing Needed to Perform MEF]@row = 0.5, "Yellow", IF([Minimum Level of Staffing Needed to Perform MEF]@row < 0.5, "Red", IF([Minimum Level of Staffing Needed to Perform MEF]@row < 0.25, "Red", "Gray")))))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?