Trigger a FLAG based on 2 Conditions (with 1 Condition being a menu selected Choice)
I'm attempting to trigger a Flag based on a Condition from a Menu Select column + a Condition that counts Days.
What I'm trying to do:
If the Menu column = Approved (as is) AND Days column equals any Count , the Flag is White (0) condition.
If the Menu column does not equal Approved (as is) AND Days column is equal to or greater than 5 , the Flag is Red (0) condition.
I used variations of this formula and I am missing some logic somewhere.... I attempted to use an OR statement to vary between the an "Approved" selection and other than "Approved" selection but its not working correctly.
-Appreciate any guidance !
=IF(AND([Approver Business Unit]@row <> "Approved (as is)", [Days Open Since Approval Request]@row >= 5), 1, OR(IF(AND([Approver Business Unit]@row = "Approved (as is)", [Days Open Since Approval Request]@row >= 5), 0)))
Help Article Resources
Check out the Formula Handbook template!