Getting data calculations from another sheet

Cayla Davis

I am trying to create a metrics sheet for my dashboard of how many issues in these categories below, are High Medium Low

Open
Currently in Pilot
Pending Development
Pending Production Release
Pending Dev Acceptance
Review with Third Party
Under Investigation
Closed

I am trying to gather the data from another sheet, but i cant seem to get it to work. Any thoughts?

Paul Newcome

What happens if you put this in the Area column on the Open row?

=COUNTIFS({Source Sheet Status Column}, @cell = [Primary Column]@row, {Source Sheet Priority Column}, @cell = Area$1)

Paul Newcome

What happens if you put this in the Area column on the Open row?

=COUNTIFS({Source Sheet Status Column}, @cell = [Primary Column]@row, {Source Sheet Priority Column}, @cell = Area$1)

Cayla Davis

I get #UNPARSEABLE

=COUNTIFS({{Sabre Traveler Care Priorities Range 1}}, @cell = [Primary Column]@row, {{Sabre Traveler Care Priorities Range 2}}, @cell = Area$1)

Update - I see what i did, extra { - i updated it and it looks to be working now. Thanks Paul!!!!! appreciate your help!

Paul Newcome

Happy to help. 👍️