Calculating Age Monthly
I have a smartsheet with many events that often span several months. I want to calculate the average age of relevant events for each month.
For example, for the month of March, I want it to calculate the average age of events that are still open in March in addition to the age of all events that were closed within the month of March.
I'm not sure where to start to achieve this.
Best Answer
-
Solved here: https://community.smartsheet.com/discussion/comment/458225#Comment_458225
Answers
-
You will need a Date Open and Date Closed column for each event. Then calculate the age. Similar to this where Age formula is:
=IF(ISBLANK([Date Closed]@row), TODAY() - [Date Open]@row, [Date Closed]@row - [Date Open]@row)
You could also just put in a Status Column with a formula to classify it as Open or Closed.
Put in another column to calculate the month. Then create a metric sheet to average the Age by month. I know there are more details, but this will get you started down the right path.
-
What do you mean when you say to "calculate the month" ?
-
Solved here: https://community.smartsheet.com/discussion/comment/458225#Comment_458225
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 395 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!