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
621 5
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

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
16 - Uranus

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.

5 Replies 5
16 - Uranus

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

5 - Automation Enthusiast

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

16 - Uranus

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')`

5 - Automation Enthusiast

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?

16 - Uranus

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.