Formula with Dates and Blank Fields

Options

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")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!