Formatting multiple choice dropdown menu with a formula

So I have a multi-select field that has about 50 or so options. I want to take those options and surround them with quotation marks, separated by a comma. I tried using the SUBSTITUTE, but I couldn’t get it to work the way I wanted without duplicating the field a few times. I did something similar to below, but now I have three extra columns in my table…heh.

SUBSTITUTE({Calculation},", ",",\"")

I am wanting to take this:
image

and turn it into this:

[“Pet Doll”,“Chubby”,“Child”,“Wings”,“Horns”,“Round Face”,“Pointed Ears”]

Complete with brackets on each end. How would I go about doing this? I don’t know if scripting will work because I’m trying to import my airtable into another service and in order for those choices to be recognized as tags, they have to be formatted as you see above. So the field has to have that data in it.

I have hundreds and hundreds of rows, so doing it by hand is not an option.

Hey man, try this out:

'["' & 
SUBSTITUTE(
  Status,
  ', ',
  '","'
) & 
'"]'

Screenshot 2022-06-09 at 1.58.10 PM

3 Likes

Wow! You are amazing. Thank you!

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.