Comma Separated Text/Number to Multi-Select Dropdown

Myals Jones

Hello, I am looking for a formula or a formatting solution to move comma-space separated, text/number, field values to a multi-select dropdown field this way when I am filtering my final report, I can use a "has any of" filter instead of having to use separate "contains" filters to find the information I need. See below example:

Something to note is that in my real spreadsheets, I have as many as 15-20 values in a particular field and as few as 0, so the solution will need to account for that as well.

jmyzk_cloudsmart_jp

Hi @Myals Jones

You can use the SUBSTITUTE function to substitute "," to CHAR(10).

=SUBSTITUTE([Starting Value]@row, ",", CHAR(10))

https://app.smartsheet.com/b/publish?EQBCT=ded72669fdd9403198568117269a4367