IF(CONTAINS ("Maine, Vermont, New Hampshire, Massachusetts, Rhode Island, New York, New Jersey, Connecticut, Pennsylvania, Maryland, District of Columbia, West Virginia, Ohio, Michigan, Indiana, Illinois, Wisconsin" , ShippingState), “North East”,
IF(CONTAINS ("Virginia, North Carolina, South Carolina, Georgia, Florida, Alabama, Mississippi, Louisiana, Arkansas, Oklahoma, Texas, Kentucky, Tennessee, Missouri, Kansas, Colorado, New Mexico " , ShippingState), “South”,
IF(CONTAINS ("Iowa, Nebraska, South Dakota, North Dakota, Minnesota, Wyoming, Montana, Idaho " , ShippingState), “North”,
IF(CONTAINS ("Canada " , ShippingCountry), “North”,
IF(CONTAINS ("Washington, Alaska, Hawaii, Oregon, Arizona, California, Nevada, Utah " , ShippingState), “West”))))))
So I tried this one:
CASE( ShippingState ,"Maine",NorthEast,
ShippingState ,"Vermont",NorthEast,
ShippingState ,"New Hampshire",NorthEast,
ShippingState ,"Massachusetts",NorthEast,
ShippingState ,"Rhode Island",NorthEast,
ShippingState ,"New York",NorthEast,
ShippingState ,"New Jersey",NorthEast,
ShippingState ,"Connecticut",NorthEast,
ShippingState ,"Pennsylvania",NorthEast,
ShippingState ,"Maryland",NorthEast,
ShippingState ,"District of Columbia",NorthEast,
ShippingState ,"West Virginia",NorthEast,
ShippingState ,"Ohio",NorthEast,
ShippingState ,"Michigan",NorthEast,
ShippingState ,"Indiana",NorthEast,
ShippingState ,"Illinois",NorthEast,
ShippingState ,"Wisonsin",NorthEast,
ShippingState ,"Virginia",South,
ShippingState ,"North Carolina",South,
ShippingState ,"South Carolina",South,
ShippingState ,"Georgia",South,
ShippingState ,"Florida",South,
ShippingState ,"Alabama",South,
ShippingState ,"Mississippi",South,
ShippingState ,"Louisiana",South,
ShippingState ,"Arkansas",South,
ShippingState ,"Oklahoma",South,
ShippingState ,"Texas",South,
ShippingState ,"Kentucky",South,
ShippingState ,"Tennessee",South,
ShippingState ,"Missouri",South,
ShippingState ,"Kansas",South,
ShippingState ,"Colorado",South,
ShippingState ,"New Mexico",South,
ShippingState ,"Iowa",North,
ShippingState ,"Nebraska",North,
ShippingState ,"South Dakota",North,
ShippingState ,"North Dakota",North,
ShippingState ,"Minnesota",North,
ShippingState ,"Wyoming",North,
ShippingState ,"Montana",North,
ShippingState ,"Idaho",North,
ShippingCountry ,"Canada",North,
ShippingState ,"Washington",West,
ShippingState ,"Alaska",West,
ShippingState ,"Hawaii",West,
ShippingState ,"Oregon",West,
ShippingState ,"Arizona",West,
ShippingState ,"California",West,
ShippingState ,"Nevada",West,
ShippingState ,"Utah",West,
0)
But that didn't work either. Both just say 'syntax error'. Any ideas?
Adriana, you were close. Just need a few ':' and correct amount of parentheses in there:
IF(
CONTAINS("Maine:Vermont:New Hampshire:Massachusetts:Rhode Island:New York:New Jersey:Connecticut:Pennsylvania:Maryland:District of Columbia:West Virginia:Ohio:Michigan:Indiana:Illinois:Wisconsin",ShippingState),"North East",
IF(
CONTAINS("Virginia:North Carolina:South Carolina:Georgia:Florida:Alabama:Mississippi:Louisiana:Arkansas:Oklahoma:Texas:Kentucky:Tennessee:Missouri:Kansas:Colorado:New Mexico",ShippingState),"South",
IF(
CONTAINS("Iowa:Nebraska:South Dakota:North Dakota:Minnesota:Wyoming:Montana:Idaho",ShippingState),"North",
IF(
CONTAINS("Canada",ShippingCountry),"North",
IF(
CONTAINS("Washington:Alaska:Hawaii:Oregon:Arizona:California:Nevada:Utah",ShippingState),"West",NULL
)))))
