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

Tags:

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭

    @ayb

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!