Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Switch formula 2 conditions

Topic Labels: Formulas
315 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Any way to rewrite this formula? Instead of looking at State for “BC”, using {City}

SWITCH(
{State},
“CT”, “New England”,
“ME”, “New England”,
“MA”, “New England”,
“NH”, “New England”,
“RI”, “New England”,
“VT”, “New England”,
“NJ”, “Mid-Atlantic”,
“NY”, “Mid-Atlantic”,
“PA”, “Mid-Atlantic”,
“IL”, “Midwest”,
“IN”, “Midwest”,
“MI”, “Midwest”,
“OH”, “Midwest”,
“WI”, “Midwest”,
“IA”, “Midwest”,
“KS”, “Midwest”,
“MN”, “Midwest”,
“MO”, “Midwest”,
“NE”, “Midwest”,
“ND”, “Midwest”,
“SD”, “Midwest”,
“TX”, “Southwest”,
“OK”, “Southwest”,
“LA”, “Southwest”,
“AR”, “Southwest”,
“DE”, “South Atlantic”,
“FL”, “South Atlantic”,
“GA”, “South Atlantic”,
“MD”, “South Atlantic”,
“NC”, “South Atlantic”,
“SC”, “South Atlantic”,
“WV”, “South Atlantic”,
“VA”, “South Atlantic”,
“DC”, “South Atlantic”,
“KY”, “Southeast”,
“AL”, “Southeast”,
“MS”, “Southeast”,
“TN”, “Southeast”,
“CA”, “Pacific”,
“AK”, “Pacific”,
“HI”, “Pacific”,
“OR”, “Pacific”,
“WA”, “Pacific”,
“AZ”, “Mountain”,
“CO”, “Mountain”,
“NM”, “Mountain”,
“UT”, “Mountain”,
“MT”, “Mountain”,
“WY”, “Mountain”,
“NV”, “Mountain”,
“ID”, “Mountain”,
“AB”, “Prairies”,
“SK”, “Prairies”,
“MB”, “Prairies”,
“ON”, “Central Canada”,
“QC”, “Central Canada”,
“NS”, “Atlantic Canada”,
“NB”, “Atlantic Canada”,
“PEI”, “Atlantic Canada”,
“NL”, “Atlantic Canada”,
)

SWITCH(
{City},
“Vancouver”, “Lower Mainland”
)

1 Reply 1

Welcome to the community, @Harrold_Ruiz! :grinning_face_with_big_eyes: You’ve got a good start with your second formula. Just continue that pattern, adding city and region pairs as needed. Or is there something about the SWITCH() structure that you don’t understand?