Date formula not working correctly
So I have the following formula
=IF(AND(GO Live Date]@row > [Actual End]@row, [Actual End]@row <> 0), "On-Time", "Exceeded")
And my result is showing # Unparsable.
What is wrong with my formula these are date columns.
Thank you
Best Answer
-
Hey @Buster Davis
Can you double check that both of your columns are set as Date Type? We can see that the Go Live Date is a Date column, so can you check that the "Actual End" column is set as Date?
I would also suggest checking to see if the Actual End is not blank versus not being 0, since a Date won't ever be 0.
=IF(AND([GO Live Date]@row > [Actual End]@row, [Actual End]@row <> ""), "On-Time", "Exceeded")
Answers
-
Missing a bracket in front of GO.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
You are missing a bracket on the GO Live Date reference.
=IF(AND([GO Live Date]@row > [Actual End]@row, [Actual End]@row <> 0), "On-Time", "Exceeded")
Hope this helps!
-
With the correction of the missing bracket, now I am getting invalid operation? Thoughts
-
Hey @Buster Davis
Can you double check that both of your columns are set as Date Type? We can see that the Go Live Date is a Date column, so can you check that the "Actual End" column is set as Date?
I would also suggest checking to see if the Actual End is not blank versus not being 0, since a Date won't ever be 0.
=IF(AND([GO Live Date]@row > [Actual End]@row, [Actual End]@row <> ""), "On-Time", "Exceeded")
-
Thank you your formula worked perfectly..
Help Article Resources
Categories
Check out the Formula Handbook template!