Average close time between dates


Hi there - i'm looking for some help with sheet summary.

I'm looking to monitor the average time between when rows are created within a sheet to the time it's completed and it be rolling 30 days. I have three columns the "created" column, "closed" column(checkbox) and a "date closed " column(date is inserted by "record a date" automation). I want to see the average time (for the entire sheet via sheet summary) between the date the rows were created and the closed date and it be for the past 30 days.

Best Answer

  • Mark Safran
    Mark Safran ✭✭✭✭✭
    edited 07/19/21 Answer ✓

    Add a helper column that does the [Date Closed]@row - [Created Date]@row math. Then your Sheet Summary Formula is an AVERAGEIF of that column with your desired condition:

    =AVERAGEIF([Date Closed]:[Date Closed], >TODAY(-30), Helper:Helper)