Help

Re: How can I have one field automatically populate another field.

Solved
Jump to Solution
3905 4
cancel
Showing results for 
Search instead for 
Did you mean: 
K_M_R
5 - Automation Enthusiast
5 - Automation Enthusiast

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

IF(Medium, 'Video/animation', 'V')
IF(Medium, 'PDF', 'G')
but it doesn't work so I assume i am doing this incorrectly, I'm new to formulas and building these tables, so any help is appreciated.
 
1 Solution

Accepted Solutions
K_M_R
5 - Automation Enthusiast
5 - Automation Enthusiast

 I added the missing quotes but still no dice

Screen Shot 2022-12-23 at 1.53.14 PM.png

See Solution in Thread

7 Replies 7
John_B2
6 - Interface Innovator
6 - Interface Innovator

Use the SWITCH function -

SWITCH(Medium,
"Video/animation", "V" ,
"PDF", "G" ,
"Poster", "P",
"O"
) 
 
The "O" for other at the end is the default if none of the conditions are true.
K_M_R
5 - Automation Enthusiast
5 - Automation Enthusiast

It is giving me an error, am I doing something wrong? 

screen grab or error attached

John_B2
6 - Interface Innovator
6 - Interface Innovator

John_B2_0-1671821193157.png

You skipped a couple of closing quotes

K_M_R
5 - Automation Enthusiast
5 - Automation Enthusiast

 I added the missing quotes but still no dice

Screen Shot 2022-12-23 at 1.53.14 PM.png

K_M_R
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

John_B2
6 - Interface Innovator
6 - Interface Innovator

Happy to help - you should be able to have multiple things = the same letter. Can you repost what your formula looks like now?

John_B2
6 - Interface Innovator
6 - Interface Innovator

Ah - I see it, You missed the comma at the end of line 6 and 7