Count Unique Assigned to values with a Specific Status


I have a COUNTIFS formula that I use in a roll-up sheet to count the number of tasks specific individuals have assigned to them on a Project Task Sheet. The values from the roll-up sheet are fed to a dashboard.

=COUNTIFS({Assigned To}, Primary9, {Status}, <>"Complete")

The problem with this formula, is that it does not work if there are multiple people assigned to the task.

As an example, because I have multiple people assigned to this task:

It does not pull in the count on the sheet that contains the COUNTIFS formula:

What formula can I use to count not only the unique number of names in the Assigned To column, but to only include the tasks that are not complete?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!