Extract Multiple Text

Hi all,

I have a drop-down list that has multiple selections, and I want to extract all of the text within parentheses into one cell.


Greatly appreciated if anyone can help.

Best Answer

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓

    @B Diamond

    How do you want to show it extracted.

    One way this can be done is you have a separate list of all these 'Z numbers' on another sheet.

    then on this sheet you use the formula below (change cross sheet reference as needed):

    =JOIN(COLLECT({cross sheet to list}, {cross sheet to list}, CONTAINS(@cell, Codes@row)), " ")

    This will just bring them in separated by a space.

    You may need to add on this other sheet a column with the parentheses (to avoid bringing back partial matches):

    =JOIN(COLLECT({cross sheet to list}, {cross sheet to list with parentheses}, CONTAINS(@cell, Codes@row)), " ")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!