Formula needed to get "State" from address

I have an Address field in a board. I’m able to extract the street number, street name, city name, country, etc. through formula columns (e.g. {Address#CityShort}, {Address#StreetNumber}, {Address#StreetShort})

However, there is no option for “State”. I’d expect something like {Address#State} but it is missing. I’ve tried some complicated formulas to try to extract the state but without luck. Are there any suggestions to get the 2-digit state based on the address field?

Do you have AI turned on your account? Could you use a text column with AI to extract that info?

1 Like