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

  • Genevieve P.
    Genevieve P. Employee Admin
    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")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!