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.
Help Article Resources
Check out the Formula Handbook template!