Skip to main content
Solved

How can I have one field automatically populate another field.

  • December 23, 2022
  • 7 replies
  • 320 views

Forum|alt.badge.img+2

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.
 

Best answer by K_M_R

You skipped a couple of closing quotes


 I added the missing quotes but still no dice

7 replies

Forum|alt.badge.img+9
  • Inspiring
  • December 23, 2022

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.

Forum|alt.badge.img+2
  • Author
  • New Participant
  • December 23, 2022

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.

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

screen grab or error attached


Forum|alt.badge.img+9
  • Inspiring
  • December 23, 2022

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

screen grab or error attached


You skipped a couple of closing quotes


Forum|alt.badge.img+2
  • Author
  • New Participant
  • Answer
  • December 23, 2022

You skipped a couple of closing quotes


 I added the missing quotes but still no dice


Forum|alt.badge.img+2
  • Author
  • New Participant
  • December 23, 2022

 I added the missing quotes but still no dice


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!


Forum|alt.badge.img+9
  • Inspiring
  • December 23, 2022

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!


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


Forum|alt.badge.img+9
  • Inspiring
  • December 23, 2022

 I added the missing quotes but still no dice


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