Help

Quick Multiple Selection Conversaion

Topic Labels: Formulas
824 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Alexander-Jerry
6 - Interface Innovator
6 - Interface Innovator

Hi!

I was wondering if there was a quicker way to do this.

I’m trying to split the categories in Column A into Different Multiple Selection Items for Column B.

I will review the similar / suggested topics as well. Thank you!

1 Reply 1

Add a formula field:

SUBSTITUTE({Activities (unformatted)}, "|", ",")

This will replace all vertical bars with commas. Now copy the entire contents of this field into your {Activities (formatted)} field, and Airtable will convert the comma-separated items into multiple-select entries record by record. Any duplicate entries will merge with existing ones.

The only trouble you’re going to run into is with the records that contain commas as part of someone’s response (i.e. the “Other” options), like record 101:

57%20PM

One way around this is to use this for the formula instead:

'"' & SUBSTITUTE({Activities (unformatted)}, "|", '","') & '"'

This will ensure that each entry gets wrapped in quotes. When copied and pasted into the multi-select field, those entries with commas will retain their commas, instead of the commas separating them into further choices. You’ll still have to deal with a bunch of “Other” items in your multi-select list, but entries like the example above will create a single item—"Other: sail, ski, paddleboard"—instead of three items—"Other: sail", " ski", " paddleboard".