Sign in to join the conversation:
Is it possible to preserve the dropdown choices when importing an excel document?
Hi,
Yes, but you must add the drop-down values to the Excel sheet multiple times to be on the safe side.
Try this.
Add the values you want to include in a drop-down like below in Column1.
Column1 - Column2 - Column3
Value1Value2Value3Value1Value2Value3Value1Value2Value3Value1Value2Value3
Did it work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I had data deleted from a column in a tracking sheet. (2K+ rows) I pulled a snapshot from the activity log and I want to pull back the data from just the one column. I was told the right process was under File>Import>Update Rows, but I don't have that option under import. Is there another way to do this?
I have an Intake Sheet in which someone can select multiple Locations and multiple Fiscal Years that the Initiative will occur in. What I need is for this row to copy to the Retail Master Sheet a total of 6 times - one for every possible combination of the selected Location and Fiscal Year. DESIRED RESULT - My current…
I am receiving errorCode: 48 on one of my sheets that is in a Workspace. All other sheets can be accessed except for the most important one. I have created 2 cases for this with no response from Smartsheet: Case# 08756481 Case# 08759594
