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.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!