I am using a Count formula to count the specific team who owns a task. I have three different teams

Deborah Berwaldt

I want to count the number of tasks for each team member. I keep getting the same answer for each team which is not accurate even though I have indicated in the formula which team I am asking to count.

SSFeatures

Hi @Deborah Berwaldt, it sounds like you're using a dropdown to assign team members to the task, and your dropdown can have multiple options selected.

In this case, you should use the COUNTIFS with CONTAINS, to check if the cell contains the option that you're checking.

For example:

=COUNTIFS({Ref}, CONTAINS("OARS", @cell))

And then another one for the other option:

=COUNTIFS({Ref}, CONTAINS("Facilities", @cell))

In this screenshot, I have a formula that counts the number of times that each team is found in my reference sheet.

This is the formula I used:

=COUNTIFS({Source1 Column2}, CONTAINS(Assignee@row, @cell))

I hope this helps!

Cayla Davis

What is the formula that you are using right now? Are you looking to count team members or the individual teams?

Deborah Berwaldt

Thank you, but I actually just figured out that it should be a COUNTIF formula. But have another question, how do I count for a cell that has two team members assigned to the task. This is what I came up with for this but it does not calculate the number. =COUNTIFS({sheet reference OARS + Facilities}, "OARS", {Sheet reference OARS + Facilities}, "Facilities")

SSFeatures

Hi @Deborah Berwaldt, it sounds like you're using a dropdown to assign team members to the task, and your dropdown can have multiple options selected.

In this case, you should use the COUNTIFS with CONTAINS, to check if the cell contains the option that you're checking.

For example:

=COUNTIFS({Ref}, CONTAINS("OARS", @cell))

And then another one for the other option:

=COUNTIFS({Ref}, CONTAINS("Facilities", @cell))

In this screenshot, I have a formula that counts the number of times that each team is found in my reference sheet.

This is the formula I used:

=COUNTIFS({Source1 Column2}, CONTAINS(Assignee@row, @cell))

I hope this helps!