Hi,
I have a table with columns for Due Date, Completion Date, and Status. In the Status column I have the formula =IF([@[Completion Date]]<=[@[Due Date]], "On-Time", "Late").
But if the Completion Date is blank, the Status column returns a "on-Time" value. How to do I get it to return a blank value?
Your help is appreciated. Thank you
Rowena
Bookmarks