Combine two multi-select fields
I have set up a formula field to combine two multi-select fields into a using the list function. It looks like this: List(";", [Select1], [Select2]) At a basic level, this works fine. However, Se...
Forum Discussion
You will need to first break up [Select 2] into its parts.
var text PartOne = Part([Select 2],1,";");
var text PartTwo= Part([Select 2],=2,";");
etc etc etc
var text PartTwenty = Part([Select 2],20,";");
var text StepOne =
List(";", [Select 1], IF(not Contains([Select 1], $PartOne), $PartOne);
var text StepTwo =
List(";", $StepOne, IF(not Contains($StepOne, $PartTwo), $PartTwo);
var text StepThree =
List(";", $StepTwo, IF(not Contains($StepTwo, $PartThree, $PartThree);
etc etc etc
var text StepTwenty =
List(";", $StepNineteen, IF(not Contains($StepNineteen, $PartTwenty, $PartTwenty);
$StepTwenty
var text PartOne = Part([Select 2],1,";");
var text PartTwo= Part([Select 2],=2,";");
etc etc etc
var text PartTwenty = Part([Select 2],20,";");
var text StepOne =
List(";", [Select 1], IF(not Contains([Select 1], $PartOne), $PartOne);
var text StepTwo =
List(";", $StepOne, IF(not Contains($StepOne, $PartTwo), $PartTwo);
var text StepThree =
List(";", $StepTwo, IF(not Contains($StepTwo, $PartThree, $PartThree);
etc etc etc
var text StepTwenty =
List(";", $StepNineteen, IF(not Contains($StepNineteen, $PartTwenty, $PartTwenty);
$StepTwenty
Oh nevermind, I see now how the if functions on each of the parts don't actually return anything, so the list wouldn't add a blank space