Show multiple contacts listed in Assigned To field in a report?
Options
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!
Best Answer
Answers
-
-
Thank you @Leibel Shuchat, this worked!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!