Need to convert excel list to a multi-select in Smartsheet

Emily McNeeley

When I imported data from Excel there were values in a list that look like this in the field: (NOT AVAILABLE); GLOBAL MARKETING ORGANIZATION; MARKETING & CONSUMER OPS - VIDEO/BB

How do I make each of these values a multi-select value so we can easily run reports without manually updating each one?

So the list in Smartsheet would have the following as values:

(NOT AVAILABLE)

GLOBAL MARKETING ORGANIZATION

MARKETING & CONSUMER OPS - VIDEO/BB

There are more values so this is just a subset as an example

Genevieve P.

Hi @Emily McNeeley

You could add a multi-select column next to this text field and then replace every instance of ";" with CHAR(10) using the SUBSTITUTE Function. This is a Line Break and will create a separate value in a multi-select column.

Try something like:

=SUBSTITUTE([Text Column]@row, ";", CHAR(10))

Cheers,

Genevieve

Genevieve P.

Hi @Emily McNeeley

You could add a multi-select column next to this text field and then replace every instance of ";" with CHAR(10) using the SUBSTITUTE Function. This is a Line Break and will create a separate value in a multi-select column.

Try something like:

=SUBSTITUTE([Text Column]@row, ";", CHAR(10))

Cheers,

Genevieve

Emily McNeeley

That worked! Thanks so much!

Genevieve P.

No problem! I'm glad that worked for you. 🙂