Split and join multi-select values into new column

laurablox
laurablox ✭✭
edited 08/31/21 in Formulas and Functions

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

  • laurablox
    laurablox ✭✭
    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

  • laurablox
    laurablox ✭✭
    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!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!