Nested IF using additional AND logical functions
I am struggling with creation of formula for defining tasks status (Green, Yellow, Red). Getting the UNPEARSEABLE or INCORRECT ARRANGMENT SET error messages.
My formula is right now as follows:
=IF(ISBLANK([RESPONSE DATE]88); "Gray", IF([RESPONSE DATE]88 <= [ORIGINAL DUE DATE]88; "Green", IF(AND([RESPONSE DATE]88 > [ORIGINAL DUE DATE]88; [RESPONSE DATE]88 <= [1st New due Date]88); "Yellow", IF([RESPONSE DATE]88 > [1st New due Date]88; "Red"))))
Maybe it is somehow related to parenthesis but I have tried a lot of combinations.
Can anybody help?