Show multiple contacts listed in Assigned To field in a report?

Jessica Takata

Hi,

I have a project sheet with multiple contacts listed in the Assigned To field, and I want to include all of them in a "Project Team Tasks by Status" report that shows the sum of all statuses by team member. I found that the tasks with multiple contacts assigned is not being accounted for in this report; only the task statuses with a single contact are included.

Is there a formula that will tell the report to account for tasks with multiple contacts assigned?

Thank you!

Leibel S

Your criteria should be:

HAS(@cell, [Primary Column]@row)

https://help.smartsheet.com/function/has

Leibel S

Your criteria should be:

HAS(@cell, [Primary Column]@row)

https://help.smartsheet.com/function/has

Jessica Takata

Thank you @Leibel Shuchat, this worked!