CountIfs Formula - INVALID REF

I am attempting to do a COUNTIFS formula with a reference to a different sheet.

This is the formula =COUNTIFS({Archived Review Responses_EMPLOYEE Range 3}, Community@row, {Archived Review Responses_EMPLOYEE Range 4,"1"})

If I use only the first criteria in a formula, which would be:

=COUNTIFS({Archived Review Responses_EMPLOYEE Range 3}, Community@row)

the formula seems to work fine.

But when I use the first formula I listed (with 2 criterion) it spits back the error "INVALID REF" and it says I need to edit the first reference. If the first reference is working in shorter formula, why won't it work in the longer formula?

Screenshot is attached of my sheet.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!