Data Shuttle - import multiple values from csv into a multi-select cell?

Stefanie S.
Stefanie S. ✭✭✭
edited 06/14/22 in Add Ons and Integrations

Is it possible to use Data Shuttle to import multiple values into a multi-select cell. If so, how do I format my csv to properly do so?

Example CSV:

"Last Name","First Name",Email,"Job Title","Faculty Type"

Doe,John,"[email protected]",Professor,"1,2"

The target multi-select column has the following values (and is restricted to those values only):




I can't figure out how to get 1 and 2 selected after running Data Shuttle. I currently get an error:

Add rows to target sheet: "The value \"\" could not be saved in column \"Faculty Type\". This column is restricted to MULTI_PICKLIST values only."


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Stefanie S.

    The reason you're receiving this error is because your multi-select drop-down is restricted to those three values, and the values in the CSV are being read as one, instead of multiple.

    "1, 2" in your CSV is seen as a selection of "1, 2" instead of "1" and "2". This means that the "1, 2" doesn't match one of your approved values in the Column Properties.

    I would suggest adding in a helper text column in your Smartsheet destination sheet (you can hide this column). Use this as the column to map your values into.

    Then have a formula that looks into that helper text column and returns 1, 2, or 3, depending on what's selected, like so:

    =IF(CONTAINS(1, [Helper Column]@row + ""), 1, "") + IF(CONTAINS(2, [Helper Column]@row + ""), CHAR(10) + 2, "") + IF(CONTAINS(3, [Helper Column]@row + ""), CHAR(10) + 3, "")

    The Multi Select would be a Column Formula so it would be locked to the three values you identify in the formula.

    Will this work for you?