How to separate multi select values and collect distinct values?

Each period (P1,P2,P3 etc) we collect KPIs for our projects. In some new KPIs we have been asked to collect the answers involve multi select drop downs.

What we would like to be able to do is to each period have a list of only the unique values.

I have tried using a formula which uses JOIN, DISTINCT and COLLECT and it works but only when all of the multi select values are the same so it can still produce some duplicates.

Is it possible to get the formula to only return unique values for that period.


Completion of low carbon assessment.

Hydrogen powered plant and equipment.

Low carbon concrete or other materials.

Solar solutions.


I hope this makes sense.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!