Formula help wanted

H.Woods

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?

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):

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):

H.Woods

Thank you Jeremy_D, that helped me solve the problem.