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
-
Try this:
=[Project ID]@row + "_" + SUBSTITUTE(Categories@row, CHAR(10), "_")
-
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), "_")Gia Thinh Technology - Smartsheet Solution Partner.
Answers
-
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!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
-
Try this:
=[Project ID]@row + "_" + SUBSTITUTE(Categories@row, CHAR(10), "_")
-
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), "_")Gia Thinh Technology - Smartsheet Solution Partner.
-
Thank you everyone for your answers, it works very well.
Best regards
-
Happy to help. 👍️
-
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!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 460 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
