Split and join multiselect values into new column
Options
laurablox
✭✭
Hi,
I'm attempting to get a function as per below.
I've tried a few methods and it doesn't seem to work. Can anyone help?
Best Answer

I've solved this with a bunch of
IF(Contains([input]@row,"XX"),"XX") + char(10) + IF(Contains([input]@row,"YY"),"YY") + char(10) + etc etc's.
If anyone has a more clever solution, please let me know! Thanks!
Answers

I've solved this with a bunch of
IF(Contains([input]@row,"XX"),"XX") + char(10) + IF(Contains([input]@row,"YY"),"YY") + char(10) + etc etc's.
If anyone has a more clever solution, please let me know! Thanks!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!