Help

Re: Switch formula 2 conditions

303 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Harrold_Ruiz
4 - Data Explorer
4 - Data Explorer

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?