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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 68K Get Help
- 474 Global Discussions
- 209 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 85 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!