Manage multiple values in a cell from a dropdown list


Good morning,

I am facing an issue on my smartsheet, i have a column (dropdown list type) that allowed multiple values per cells and i am trying to manage these different values in order to concatenate them the way i want in another cell.

Does anybody knows the way to pick a single value from all of them or even the way the values are managed (separated) in the cell to write a formula ?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!