Countifs with multiple variables.


I'm trying to count the number of each Request Type for the current month based on the Created Date pulling data from the Sheet - Engagement Request Tracking with Form.

Here's a picture of my source sheet:

Here's a picture of my sheet to capture the totals:

If tried using several formulas and can't seem to come up with anything that seems to work. Here's one of the formulas I tried:

=COUNTIFS({Sheet - Engagement Request Tracking with F Range 1}, Category@row, [{Sheet - Engagement Request Tracking with f Range 4}, IFERROR(MONTH(@cell), 0) = Month(Today())])

Any suggestions? I'm still learning so please keep that in mind... :-)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!