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

Jessica Takata
Jessica Takata ✭✭✭
edited 03/21/23 in Formulas and Functions


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!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!