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!