Average close time between dates

Jason Jordan

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.

Mark Safran

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)

Mark Safran

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)

Jason Jordan

this worked perfectly thank you so much!