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")
Answers
-
Hey @SmeyerEnpointe
=IF(ISDATE([Proof Due Date]@row, IF([Completion Date]@row > [Proof Due Date]@row, "Late", "On-time"),"No Proof Date")
Does this work for you?
Kelly
-
I get an error incorrect argument
-
oops. I typed too fast. I forgot the closing parenthesis of the ISDATE
=IF(ISDATE([Proof Due Date]@row), IF([Completion Date]@row > [Proof Due Date]@row, "Late", "On-time"), "No Proof Date")
-
Works perfectly, thank you
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!