Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

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

✭✭✭✭✭
edited 02/21/25 in Smartsheet Basics

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

Answers

Trending in Smartsheet Basics