Listing Distinct Values from Multiple Contact Cells
I have a shift Rota here which displays this weeks labour allocation.
I want to create a list with each person who shows up on the shift rota.
I've thought about converting each shift row or day column to a multi select column in another column, then using something like Collect(Distinct(..) To get unique names but could not get anything to work.
Many thanks in advance!
Answers
-
Are you wanting these to be output as actual useable contacts, or are you just wanting to list out the names for display/informational purposes only?
-
Hi Paul,
informational purposes only, does not have to be a contact column.
-
In that case try a JOIN/COLLECT in a multi-select column and then use CHAR(10) as your delimiter in the JOIN function.
-
apologies, I forgot to mention the list I want created from the shift rota, shows each distinct value in a different row.
For example it would list each person showing up in the rota in a column like the one on the right
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!