Welcome!

Preserving drop down list on import

Is it possible to preserve the dropdown choices when importing an excel document?

Sales

Manufacturing

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

Value1

Value2

Value3

Value1

Value2

Value3

Value1

Value2

Value3

Value1

Value2

Value3

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Unlicensed Users cannot enter data in the sheet, when they could before the changes
I have tried to set them as Edit - can share, Edit - cannot share, and commenter and nothing works, they cannot add data to the sheet. Does anyone have a solution?
How to Preserve INDEX Formula Data When Archiving Row?
The Issue My project-specific metadata sheets use INDEX/MATCH formulas that reference the Intake sheet using a Project ID. When the automation archives rows from the Intake sheet, these formulas break because they can no longer locate the source data. Example formula: =INDEX({Project Intake Name}, MATCH([Project ID 1]@row,…
2 of 5 automation workflows in a SMartSheet randomly stopped performing?
Two of my five automation workflows appear to have just randomly stopped performing on April 9, 2026. All others, which would/are performing as normal and would be functioning alongside the other workflows, are functional and appear to be untouched by this 'bug'. Help I've tried all that I can think of.