Rollup of contacts into a single cell as a single select or comma sep string?
I have a project plan with 100 tasks.
Each task can have one or more assignees in the Assigned To column.
I want to have a rollup of all possible assignees into a single cell for project filtering (as opposed to task filtering).
I understand i can not do a formula with multiple contacts. I am OK to translate this into a multi-select cell or a text cell with comma separated values for this rollup cell itself.
The problem with my Distinct(Collect formula is that its treating each cell as the unique string as opposed to treating the individual names in each cell as the unique strings. Is there a formula that can analyze the collected strings and remove duplicates? This way if "NAME-A" appears in 6 different tasks with other combinations of names, the end rollup would still only see that as a single "NAME-A".
=JOIN(DISTINCT(COLLECT([Assigned To]43:[Assigned To]150, [P/C]43:[P/C]150, ="CHILD")), " , ")
Help Article Resources
Check out the Formula Handbook template!