# Pulling monthly numbers formula

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.

• ✭✭✭✭✭✭

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)

• ✭✭✭✭✭✭

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)

• your amazing thank you so much Kimberly!

• ✭✭✭✭✭✭

you are welcome @Heather Szukis! 😀

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!