Help

Switch formula 2 conditions

Topic Labels: Formulas
277 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?

Labels