Referencing Multi-Select Dropdown in a Formula to Get Elements On One Line

Hey everyone,

By default, if you a cell in a multi-select dropdown column with more than one option selected and then copy/paste that cell or reference it in a formula, each element is pasted on a separate line, like this:

Is it possible to get all the elements on one line with commas, like this?


👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner

If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!

PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!