Formula with Dates and Blank Fields
I have this formula that shows if a project is completed on time or if it is late. But there are occasions the the Proof Due Date will be blank. How would I modify this formula to say No Proof Date, if the field Proof Due Date is blank?
=IF([Completion Date]@row > [Proof Due Date]@row, "Late", "On-time")
Help Article Resources
Check out the Formula Handbook template!