Forum Discussion
Solved
if statement for multiple date conditions
I'm looking to create an if statement that returns the 4 scenarios listed below. The highlighted scenarios in red are where I seem to be having difficulties. Confirmed Late = Actual Delivery is a...
The problem was that Excel expects a space before AM/PM. I have converted the values for you - see attached.
Perhaps
=IF([@[Actual Delivery]]="",
IF(NOW()<[@[Target Delivery (Late)]],"In Transit","Uncomfird late"),
IF([@[Actual Delivery]]<[@[Target Delivery (Late)]],"On Time","Confirmed late")
)
I went ahead and tried this formula but it seems to be missing the "Unconfirmed Late" flag. he highlighted fields in the screenshot are returning as In Transit but should flag as Unconfirmed late because it is now after the Target Delivery Date.