Average Turnaround Time
1) I have a column for turnaround time, which calculates end date minus begin date, considering holidays and workdays. I then do a summary formula which averages the total turnaround time.
2) I have another column duration, which calculates today's date minus the begin date.
3) I have another column that is a status of either HOLD, APPROVED OR REJECTED.
The problem with my average turnaround formula is that it doesn’t take into account the turnaround time for those that are on hold because there is no end date yet. How would I calculate turnaround time for both end minus begin dates AND the duration of HOLD rows?
Answers

You would need to use something as an end date. I personally use tomorrow plus the expected duration as a "placeholder" date.

Thanks Paul. I was able to SUM up the amount days for the beginning and end dates as well as SUM up the HOLD duration days using IF AND formulas. I then added the those sums for a total. I also counted the total # of requests, in which I used the total sum divided by the count and got the live average.

Great! Glad you were able to find a working solution. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!