COUNTIF or COUNTIFS - Count specific criteria in the current month


I'm trying to count all the P2's that occurred in the current month without having to change my formula every month. I have to change the "05" for May to the corresponding month each month. Here is my current formula:

=COUNTIFS({2020 from Ethica Date}, LEFT(@cell, 2) = "05", {Priority}, "P2")

I use the same formula for the previous month and change the "05" to "04" so I can capture April. There are multiple priorities so it is time consuming and I really want this somewhat automated.

I use this formula on another page that is similar but I don't need to break it down by priority:

=COUNTIF({Month To}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()))

I feel like I have searched all over this forum looking for the answer and I'm certain it's out there, I just can't figure it out. Please help!!


Sheryl Roland

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!