IF logic formula

JinwonK

Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details:

A) Test 2 and 3 with date = Correct outputs, but for

b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do?

C) For Test 1 formular seems working. But I'd like to incorporate into one formular, if feasible = Output of "OTD", or "Not", or "WIP"

I'm open to all advice and tips! Thank you.

Michelle Choate 2

So it would just be combining these in order of operations - Whatever you want to be the most important output and that could possibly be triggering another part of your equation later, put first because the automation is going to read the equation from the beginning and stop whenever the criteria is met.

So for your formula it would be 3 IF statements:

= IF([Completed Date]@row <= TODAY(), "WIP, IF(OR([Completed Date]@ow <= [Due Date]@row, [Completed Date]@row =""), "OTD", IF([Completed Date]@row > [Due Date], "Not")))