need help with formula

need help with formula

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.

Answers

  • Andrée Starå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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • 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å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?

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.