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

Elizabeth Jones · 09/09/20

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

Paul Newcome · 09/10/20

Stian Johansen · 01/27/21

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 · 01/27/21

@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 · 01/27/21

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 · 01/27/21

@Stian Johansen Happy to help. 👍️

Raul Cabrera · 09/28/21

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 · 05/31/24

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.

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

Answers

Help Article Resources

Categories