Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

IF Column One is prefixed A, then X

Topic Labels: Formulas
Solved
Jump to Solution
621 5
cancel
Showing results for 
Search instead for 
Did you mean: 

Trying to achieve an outcome where:

IF Column One is prefixed 381 then Apple
If column one is prefixed 382 then orange
etc

Column 1
381-9287
382-2818
383-2812

Column 2
formula

Thanks!

1 Solution

Accepted Solutions

Well its not possible for anything to fit all those conditions so you could just write them all in the same formula separated by an ampersand.

SWITCH(LEFT({Column 1}, 2), '5v', 'Blue')&SWITCH(LEFT({Column 1}, 4), '123a', 'Metal')&SWITCH(LEFT({Column 1}, 3), '381', 'Apple', '382', 'Orange')

A nested IF() statement could also work.

See Solution in Thread

5 Replies 5

SWITCH(LEFT({Column 1}, 3), 381, 'Apple', 382, 'Orange')

Hey Camille, thanks for your input! Unfortunately, the cell returns nothing with your formula…any ideas?

If Column 1 in your base is a text field as opposed to a number field, add single quotations around the 381 and 382 in the formula: SWITCH(LEFT({Column 1}, 3), '381', 'Apple', '382', 'Orange')

Cool, thanks!

How would I incorporate SWITCH(LEFT({Column 1}, 2), ‘5v’, ‘Blue’, ) and SWITCH(LEFT({Column 1}, 4), ‘123a’, 'Metal;) into the same formula as the one you wrote out above?

Well its not possible for anything to fit all those conditions so you could just write them all in the same formula separated by an ampersand.

SWITCH(LEFT({Column 1}, 2), '5v', 'Blue')&SWITCH(LEFT({Column 1}, 4), '123a', 'Metal')&SWITCH(LEFT({Column 1}, 3), '381', 'Apple', '382', 'Orange')

A nested IF() statement could also work.