Im looking for a better way to assigns and organize zip codes for daily routes, right now we have a zone system and each zip code equals a specific zone, Example, Zip code 123 will be Zone 1 and zip code 1234 will be zone 2. I would like to have the zone column automatically populate based off what zip code is already in the zip code field or a drop down to have multiple zones already programed in and easily selectable, any help is greatly appreciated in advance and thank you all!
Hey Berto,
I am thinking this could potentially be achieved using a formula column. Can I ask what columns you’re using for the zone system currently? For example, the zip code number and zip zone? This will help me understand how we can set this up! Thanks 
So i created each zip code in a formula but it seems like there is a limit on that column, of 1000 characters which is very disappointing, how else would i possibly go around building something like this,
Hey @nlopez1907 - rather than a formula, if you created an separate board with the Zip Codes and Zones, then add a Connect Board column on your main board and use the following match automation:
When zipcode changes new connect board column the item where the new value matches Name in New Zip Codes Board by overwriting the connected item
Then mirror the Zone from the Zip Code board back to the main board.
Hope this helps!
Mark