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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives