I want to calculate the number of days using two date fields, and if blank use today.
I want to calculate the Days to Build field by counting the number of days from the Ready for Customer QA minus the Build Start Date. And if there is no date in Ready for Customer QA I want to know how many days from today - Build Start Date
Best Answer
-
Hey @Danielle Maroon
Try this. The formula first checks to see if [Ready for Customer QA] is a date. If yes, the two column dates are subtracted. If no, TODAY() is used as one variable.
=IF(ISDATE([Ready for Customer QA]@row, [Ready for Customer QA]@row-[Build Start Date]@row, TODAY()-[Build Start Date]@row)
Will this work for you?
Kelly
Answers
-
Hey @Danielle Maroon
Try this. The formula first checks to see if [Ready for Customer QA] is a date. If yes, the two column dates are subtracted. If no, TODAY() is used as one variable.
=IF(ISDATE([Ready for Customer QA]@row, [Ready for Customer QA]@row-[Build Start Date]@row, TODAY()-[Build Start Date]@row)
Will this work for you?
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!