Countifs with 2 criteria - Date and multi-select drop down

Hi all I am trying to get this formula to work but keep getting errors...does anyone know what's wrong?

=COUNTIFS({IL Marcomm Content Calendar 2020 - Global Range 2}, IFERROR(MONTH(@cell), 0) = 1, {IL Marcomm Content Calendar 2020 - Global Range 4}, CONTAINS([Column7]5), @cell))

Global range 2 is a date column (1/1/20)

Global range 4 is a multi-select drop down column

I am using a formula sheet to generate the counts in order to create Dashboard summaries. Therefore, the "contains" reference is pulling from a reference cell with the value I am looking to count.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!