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.
I hope this makes sense.
Help Article Resources
Check out the Formula Handbook template!