Multiple Criterion with Cross Sheets


Hello I am stumped. I have tried several different combinations to my formulas trying to get them to function. I get an #UNPARSEABLE error most of the time.

I have tried this formula =COUNTIFS({Complete Claim Status}, Status@row, {Vendor Name}, [Vendor Name]@row)

Complete Claim Status is the range on my cross sheet | Status@ row is from my main sheet

Vendor Name is the second range on my cross sheet | [Vendor Name]@row is from my main sheet and I have removed the brackets as well around that as well.

Here is a screenshot. Thank you for your assistance.


Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓

    @Melanie S

    =COUNTIFS({Complete Claim Status}, =Status@row, {Vendor Name}, =[Vendor Name]@row)

    This formula worked for me. I set up 2 separate test sheets like so:

    The 2nd sheet in the Count column is where I placed that formula. It's setup with cross-sheet references as so:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!