How do I show the names of the individuals assigned to tasks for the project on the dashboard?

Sara Ross

My project sheet has an "Assigned To" column that indicates who is responsible for each task. In creating a dashboard, I would like to include a widget that references the individuals involved in the project. Often a person is responsible for several tasks, but I only want the name to be referenced once on the widget and I want it to be updated automatically if individuals are added or changed. Any suggestion on how to accomplish this?

Andrée Starå

Hi @Sara Ross

I hope you're well and safe!

You could use something like JOIN DISTINCT and COLLECT.

Try something like this.

=JOIN(DISTINCT(COLLECT([Assigned To]:[Assigned To], [Assigned To]:[Assigned To], <>"")))

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sara Ross

Thank you for the response. The formula did work mostly. However, if multiple individuals were assigned to the same task, all of the names were displayed (even if a name had already been displayed). Any ideas on how to resolve this?

Thanks!

Sara