COUNTIF referencing another sheet with one criteria and date range

Hi,

I'm creating a metric sheet that will pull data from a source sheet. I'd like to count the number of times a certain category is listed within a given month.

So far, I have =COUNTIF({Grievance Category}, "Appeal") and now I need to add the criteria of Date Received = January.

Any help is appreciated!

Julie

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!