I have set up a datasheet and need to get a count of items that match my primary column value and I

J. Earp

Michelle Choate 2

I think you are looking for

=COUNTIFS({Staff Assignment}, HAS(@cell, "ARS"), {RAG}, [Primary Column]@row)

J. Earp

I have set up a datasheet and need to get a count of items that match my primary column value and are assigned to various team members that are in a multiselect column. I tried this formula =COUNTIFS({Staff Assignment}, HAS({Staff Assignment}, "ARS"), {RAG}, [Primary Column]@row), but I get a "0" value. Would appreciate any suggestions. Thank you!

Michelle Choate 2

I think you are looking for

=COUNTIFS({Staff Assignment}, HAS(@cell, "ARS"), {RAG}, [Primary Column]@row)

J. Earp

That worked! Thank you so much!!! @Michelle Choate 2

Michelle Choate 2

@J. Earp My pleasure! Please make sure to accept my answer as the correct one for this question :)