Month/Year Row Count Function

Neisha Fredericks
Neisha Fredericks ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello All,


Can someone help me figure out why this formula is not working anymore? 

=COUNTIFS({OSPO Engagements Archive complete date}, IFERROR(MONTH(@cell), 0) = 1, {OSPO Engagements Archive Hierarchy}, =0, {OSPO Engagements Archive complete date}, IFERROR(YEAR(@cell), 0) = 2019)

It used to count all of the rows for a specific month and year where the hierarchy was "0". It is now returning "Incorrect Argument".



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!