Count Ifs giving error

Rochelle_B ✭✭✭
edited 12/09/19 in Formulas and Functions

I've created the following cross sheet CountIfs formula:

=COUNTIFS({Hutto NA Status}, "Done", {Hutto NA Owner}, [Primary Column]15, {Hutto NA Date}, >TODAY(-7))

Each segment works perfectly on its own but when I combine them, I keep getting an #INCORRECTARGUMENT error. I'm not sure what the issue is.

Appreciate anyone's help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!