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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!