copy data from excel and enter into smartsheet with multiselect column

I have a report in Excel that I want to transfer regularly over into Smartsheet for dashboard reporting. One of the columns is a dropdown list that allows for multiple values. I am having trouble formatting it to where when copied from Excel, it paste into Smartsheet as the selected values. When I copy/paste, the cells with multiple values are pasting as text and not the dropdown options.

Example: the Columns dropdown options are "One", "Two", "Three". Whether I have it in Excel as "One, Two" or "One Two", it still paste as text in Smartsheet instead of showing as both "One" and "Two" dropdown list selections.

Any ideas?

Find more posts tagged with

Importing and Exporting

copy

Multi-Select Dropdown

Accepted answers

Sandy Drew

If you have the excel value listed out with an Alt+Enter character between each value, it will translate correctly into Smartsheet as your listed values.

Excel: (all in one cell listed as below)

One

Two

Three

Smartsheet:

All comments

Sandy Drew

If you have the excel value listed out with an Alt+Enter character between each value, it will translate correctly into Smartsheet as your listed values.

Excel: (all in one cell listed as below)

One

Two

Three

Smartsheet:

BSReid24

That solution worked, thank you @Sandy Drew

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.