Forum Discussion

MICHAELSARGENT's avatar
MICHAELSARGENT
Qrew Cadet
2 years ago

Pipelines - Addressing a Multi-Select option containing commas

Setup I have an application with two tables (really more than two but the issue is surrounding two specific tables), and each of those tables contains a multi-select field with the same options.  I...
Pipelines
PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
2 years ago
HI Michael,

You can try the following formula , assuming your field name is Comment

Create a Multi Select Formula 

var text a=Part(var text b=Part(var text c=Part(

Split(List(" ; ",$a,$b,$c))


Don't worry about a messy formula , multi select can display upto 20 options max , so fire away as many parts you need

------------------------------
Prashant Maheshwari
------------------------------