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.

Best Answer

  • Kimberly Loveless
    Kimberly Loveless ✭✭✭✭✭✭
    Answer ✓

    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)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!