What is wrong with this formula?

Carole M.

This formula has been working perfectly, but now I am getting an "Invalid Operations" error. What am I missing?

=IF(OR(AND(Resolution@row = "BH: On-Hold", [Due Date]@row < TODAY()), AND(Resolution@row = "Correction: Need Follow-Up", [Due Date]@row < TODAY())), "No", IF(OR(AND(Resolution@row = "BH: On-Hold", [Due Date]@row >= TODAY()), AND(Resolution@row = "Correction: Need Follow-Up", [Due Date]@row >= TODAY())), "Hold", IF(OR(Resolution@row = "BH: Released", Resolution@row = "BH: Changed to Non-Funded", Resolution@row = "Corrected", Resolution@row = "Notified", Resolution@row = "HOS President Approved Billing"), "Yes")))

The first two conditions are working just fine, but where I am seeing the error message is when the final condition is true.

Hope someone can see what I am not.

Thanks.

RickyT

Is it because its trying to understand what the other part of the initial OR is?

Carson Penticuff

That is very odd. I am not sure what the problem could be, but I have your exact formula working in a test sheet with no issues.