Date formula / duration question
Hi there,
I have a Start Date column, an End Date Column, and a Duration (days) column.
When the Start Date column is populated, I'd like for the Duration (days) column to count the number of days between start date until today. Only once the End Date column is populated, would I like for the Duration (days) column to lock the number of days and stop counting based on today's date.
Thank you in advance!
Best Answer
-
thanks @Paul Newcome !
Answers
-
Try something like this...
=IF([End Date]@row = "", TODAY(), [End Date]@row) - [Start Date]@row
-
thanks @Paul Newcome !
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!