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!!

Thanks,

Sheryl Roland

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!