I want to count items within current month without needing to change the month manually

Elizabeth Jones

oh goodness; thanks so much for the correction. works great!

Paul Newcome

@Elizabeth Jones Happy to help. 👍️

Stian Johansen

Hi @Paul Newcome ,

I can't get the formula to work with reference to another sheet. It works perfect in the same sheet, but #UNPARSEABLE when referencing.

=COUNTIFS({Another sheet}:{Another sheet}; AND(IFERROR(MONTH(@cell); 0) = MONTH(TODAY()); IFERROR(YEAR(@cell); 0) = YEAR(TODAY())))

Paul Newcome

@Stian Johansen When referencing another sheet, you only enter the range once like so...

=COUNTIFS({Another sheet}; AND(IFERROR(MONTH(@cell); 0) = MONTH(TODAY()); IFERROR(YEAR(@cell); 0) = YEAR(TODAY())))

Stian Johansen

https://community.smartsheet.com/discussion/comment/276987#Comment_276987

That was quick and works! Can't think I didn't try that. Thank you :)

Paul Newcome

@Stian Johansen Happy to help. 👍️

Raul Cabrera

https://community.smartsheet.com/discussion/comment/243166#Comment_243166

Excellent it works for me with some other arguments that i need to filter. Thanks Paul

Stephanie Jai

https://community.smartsheet.com/discussion/comment/276987#Comment_276987

https://community.smartsheet.com/discussion/comment/242873#Comment_242873

Paul - thank you some much, as many ways as I tried and searched I kept getting faulty answers using various formulas. The one from March really made the difference.