What would be the Formula for Dates to How many Days calculation?
What is the formula to tally these columns to automatically calculate how many days the each action takes to happen?
Submitted Date to First Worked on would be for Days to First Action
First Worked on date to Completed Date would be for Days to Complete
Submitted Date to Completed Date would be for Days Since Submitted
Answers
-
Calculations on dates are similar to calculations on numbers.
Days to First Action
=[Submitted Date]-[First Worked On]
Days to Complete
=[Complete Date]-[First Worked On]
However - is it possible to complete something without working on it? This formula will throw an inaccurate result since there is no First Worked On date populated. If this is something you need to test for before measuring the date range, you may want to consider using an IF statement to test for the blank date before attempting the calculation.
Days Since Submitted
=[Completed Date]-[Submitted Date]
However - on Days Since Submitted, if the product isn't complete, don't you still want to measure it to determine if something is lagging excessively in the work queue?
Let me know how that works for you.
-
I think so, I will try it out.
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!