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
-
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)
Answers
-
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)
-
this worked perfectly thank you so much!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives