Manage multiple values in a cell from a dropdown list

Clément Q

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 ?

Paul Newcome

Try this:

=[Project ID]@row + "_" + SUBSTITUTE(Categories@row, CHAR(10), "_")

Gia Thinh

Hi bros,

I have met this issue and found that there is a line feed character CHAR(10) between the values. You can replace it with "_" using the following formula in the Codification column. Hope it works for you.

=[Project ID]@row + "_" + SUBSTITUTE(Categories@row, CHAR(10), "_")

Andrée Starå

https://community.smartsheet.com/discussion/123397/manage-multiple-values-in-a-cell-from-a-dropdown-list

Hi,

I hope you're well and safe!

Not sure I follow!

Can you elaborate?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Clément Q

To explain my current situation, you will find bellow a simple exemple about what i am trying to achieve :

The codification is a concatenation of Project ID and Categories with "_" between them, but in the case of multiples categories i did not find a way how to consider each of the value. For exemple line 4 i am trying to have 4_A_C as codification rather than 4_A C.

In order to find a solution, i have tryed to understand how the values are considered by smartsheet so i have created two more columns (simple and wrap) which are the same (=Categories@row) but the view/display is different.

Paul Newcome

Try this:

=[Project ID]@row + "_" + SUBSTITUTE(Categories@row, CHAR(10), "_")

Gia Thinh

Hi bros,

I have met this issue and found that there is a line feed character CHAR(10) between the values. You can replace it with "_" using the following formula in the Codification column. Hope it works for you.

=[Project ID]@row + "_" + SUBSTITUTE(Categories@row, CHAR(10), "_")

Clément Q

Thank you everyone for your answers, it works very well.

Best regards

Paul Newcome

Happy to help. 👍️

Andrée Starå

https://community.smartsheet.com/discussion/comment/441046#Comment_441046

Excellent!

Happy to help!

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!