Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 23, 2022 08:15 AM
I am looking for help, hopefully I can explain this well enough.
In my Airtable, I have a multiple select field where you can choose different available mediums. (Video, animation, poster, pdfs etc). And I want to create another column that automatically changes depending on what is selected. If video or animation is selected, a V would appear in the column next to it. If a “poster or PDF” is chosen a G would appear.
I cannot figure out what Formula to use.
Basically I want it to be “if this is selected” then “show this”
I tried creating a formula column and added
Solved! Go to Solution.
Dec 23, 2022 10:53 AM
Dec 23, 2022 09:49 AM
Use the SWITCH function -
Dec 23, 2022 10:37 AM
Dec 23, 2022 10:46 AM
You skipped a couple of closing quotes
Dec 23, 2022 10:53 AM
I added the missing quotes but still no dice
Dec 23, 2022 10:59 AM
I got it with your help, thank you! It turns out I can't have multiple things change to the same letter. Once i removed them it worked! THANK YOU John_B2!
Dec 23, 2022 11:39 AM
Happy to help - you should be able to have multiple things = the same letter. Can you repost what your formula looks like now?
Dec 23, 2022 11:48 AM
Ah - I see it, You missed the comma at the end of line 6 and 7