If Dates Error

LeoCicio

I want the actual date to reflect the due date only if it's not pushed. The formula I have produces #INVALID OPERATION. TIA

bisaacs

Hey @LeoCicio,

You're trying to compare a date to a number, which is why you're getting the INVALID OPERATION error.

In the logical operation part of the IF statement, change that to using NOT(ISBLANK()):

=IF(NOT(ISBLANK([Push Due Date]@row)), [Push Due Date]@row, [Due Date]@row)

Hope this helps!

bisaacs

Hey @LeoCicio,

You're trying to compare a date to a number, which is why you're getting the INVALID OPERATION error.

In the logical operation part of the IF statement, change that to using NOT(ISBLANK()):

=IF(NOT(ISBLANK([Push Due Date]@row)), [Push Due Date]@row, [Due Date]@row)

Hope this helps!

LeoCicio

That worked flawless. Thank you!