Counting AVG Days
Might be a simple solution, but I've been playing around with it long enough and give up.
I'm trying to calculate the average amount of days to complete a process, for example;
Process Start Date End Date
Process 1 09/03/2022 09/20/2022
Process 2 09/06/2022 09/16/2022
Process 3 10/01/2022 10/10/2022
And so on.
What I am trying to accomplish is to capture the cumulative average number of start and end days for all processes, so I can say our process takes x amount of days on average.
I hope that makes sense.
Thanks
Answers
-
If you're not adding new Processes all the time, you can use a static formula such as this:
=AVG(NETDAYS([Start Date]@row, [End Date]@row), NETDAYS([Start Date]2, [End Date]2), NETDAYS([Start Date]3, [End Date]3))
However if you're adding Processes all the time which I'm guessing you are, you'll want to do it like this. Add a helper column with a column formula in it such as:
=NETDAYS([Start Date]@row, [End Date]@row)
Then you can make a Sheet Summary cell with a formula such as this:
=AVG([# of Days]:[# of Days])
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!