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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!