Pulling monthly numbers formula

Heather Szukis

I  am trying to use a smartsheet to report the number of alerts received during an entire month. There are 9 types of alerts and I need to know how many we had for a specific month. The information is being pulled from another smartsheet log which has dates going back to 1/1/2020. The below metric and formula I created is pulling alerts from not just 06/01/2021 but also 06/01/2020 creating inaccurate data.

My formula is highlighted, what can I do to ensure just alerts for June 2021 are pulled. This is a formula my team will use often as we report monthly metrics and our reports includes year after year data.

Kimberly Loveless

you could add another condition to the formula (like the one to look at the month of the date in Date1) for the year. I think it would be like this

=COUNTIFS({Date Entered}, IFERROR(MONTH(@cell),0)=MONTH(Date$1), {Date Entered}, IFERROR(YEAR(@cell),0)=YEAR(Date$1), {method received}, Types@row)

Kimberly Loveless

you could add another condition to the formula (like the one to look at the month of the date in Date1) for the year. I think it would be like this

=COUNTIFS({Date Entered}, IFERROR(MONTH(@cell),0)=MONTH(Date$1), {Date Entered}, IFERROR(YEAR(@cell),0)=YEAR(Date$1), {method received}, Types@row)

Heather Szukis

your amazing thank you so much Kimberly!

Kimberly Loveless

you are welcome @Heather Szukis! 😀