Copy and Pasting Multiple Rows from Excel into One Multi Dropdown Select Cell in Smartsheet

Good Morning fellow smartsheeters!!!
Is it possible to copy and paste multiple rows from excel into one cell in smartsheet when that cell is apart of multi dropdown select?
For my use case, Each Market as an offer associated with it in column D. So essentially these markets in column c are grouped by the Offers in Column D. We want to ability for when the excel is filtered in column D to be able topy and paste the market rows from excel into smartsheet.
So When this Excel is filtered to a specific offer, we want to be able to copy these 6 markets
Into this Markets Column in Smartsheet which is a multi dropdown selection. Whenever I do a normal copy and paste it just pastes to multiple rows in the SS and when I double click into the cell in ss it just pastes the 6 markets from the example above as 1 string and not multiple selections
I am not sure if I need to do something in Excel to mimic the properties of the Multi Drop Down in Excel or if this kind of copy and paste is truly not compatible between the two. I have tried two potentially fixes in Excel by using a TEXTJOIN formula to group the Markets together based off the offer verbage
And I also tried using VBA code and data validation to be able to group them as well based on what is filtered but both of these excel methods are still pasting the markets as a single string in Smartsheet
I know this is pretty long winded, so apologies for the long read but thanks to all who take the time to read and assist!!
Best Answer
-
Yes. It would be in the TEXTJOIN in Excel. You are currently using a space " ". Replace that with a line break CHAR(10).
=TEXTJOIN(" ", ……………….)
becomes
=TEXTJOIN(CHAR(10), …………………)
Answers
-
Use a CHAR(10) delimiter. This is a line break and is the default delimiter in a multi-select dropdown type column which means pasting the values into a cell with line breaks between the selections should get them treated as separate selections within the same cell after pasting.
-
@Paul Newcome Where would I insert that at? Somewhere in the excel? I do not think I can do that in SS since that market column needs to be able to make selections and copy/paste into
-
Yes. It would be in the TEXTJOIN in Excel. You are currently using a space " ". Replace that with a line break CHAR(10).
=TEXTJOIN(" ", ……………….)
becomes
=TEXTJOIN(CHAR(10), …………………)
-
Thank you so much
-
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 432 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives