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

Stefanie S.

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,"abc123@name.com",Professor,"1,2"

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

1

2

3

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 \"com.navigo.smartsheet.rest.helper.sheet.cell.model.MultiPicklist@44b6caf1\" could not be saved in column \"Faculty Type\". This column is restricted to MULTI_PICKLIST values only."

Genevieve P.

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?

Cheers,

Genevieve