Formula help wanted

I'm trying to return a count of the number of cells that a) have a specific issue type and b) have an issue date within the last 7 days (I also want to duplicate the formula for 14, 30 and 90 days).

I'm fairly new to smartsheets and formulas and I can't figure this out. I've managed the total count (i.e. the total count of "damages" issue but I want to find the count of "damages" issues for the last 7 days.

This is where I want the formula and the value output.

The data is from a separate sheet as below

Please can someone help?

Find more posts tagged with

Formulas

Time Calculation

Countif

Accepted answers

Jeremy_D

There's probably a few ways to do this but I would create a helper column. I made one called 'Days Passed' in the sheet where the dates are and inputted the formula =TODAY() - [Days Passed]@row that will give you how many days have passed from issue.

If you then input a Countifs formula it can count based on the issue type and days passed. Please see the example below (note I did it all in the same sheet):

All comments

Jeremy_D

If you then input a Countifs formula it can count based on the issue type and days passed. Please see the example below (note I did it all in the same sheet):

H.Woods

Thank you Jeremy_D, that helped me solve the problem.

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.