COUNTIFS Reference another sheet #UNPARSABLE


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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!