Count tickets created in a specific month

Hello all,

I am trying to setup a formula for all closed tickets based by month. I tried to make this formula below work but it's giving me a 0 count. Can someone please help? My criteria is for the ticket to be closed and to fall under a certain month.

=COUNTIFS({All Tickets Range 1}, "Closed", {All Tickets Range 2}, "MONTH(@cell) = 7")

Any help is very appreciated

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!