Listing Distinct Values from Multiple Contact Cells

JPFORDTE

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!

Paul Newcome

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?

JPFORDTE

https://community.smartsheet.com/discussion/comment/325240#Comment_325240

Hi Paul,

informational purposes only, does not have to be a contact column.

Paul Newcome

In that case try a JOIN/COLLECT in a multi-select column and then use CHAR(10) as your delimiter in the JOIN function.

JPFORDTE

https://community.smartsheet.com/discussion/comment/325250#Comment_325250

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