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.

Find more posts tagged with

Formulas

Accepted answers

kss5229

Solved here: https://community.smartsheet.com/discussion/comment/458225#Comment_458225

All comments

dojones

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.

kss5229

What do you mean when you say to "calculate the month" ?

kss5229

Solved here: https://community.smartsheet.com/discussion/comment/458225#Comment_458225

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.