Preserving drop down list on import

LB Kline
LB Kline
edited 12/09/19 in Smartsheet Basics

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

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 05/08/19

    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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.