COUNTIFS Reference another sheet #UNPARSABLE

Hello,

I am trying to use COUNTIFS to count the occurrences of 'On Call' in one range and 'Account' in another range. Both ranges are in another sheet.

=COUNTIFS({From_Trackit_Data Range 8}, "On Call", {From_Trackit_Data Range 7},"Account")


What am I doing wrong?

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!