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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives