Formatting non-US zip codes

[leletran]

Hello,

Hope all is well! My apology if this was answered elsewhere. I searched the forum and google'd but was not able to find relevant results. I'm working on a shipment dashboard and we send shipments locally and internationally. Thus, we have zip codes that contain both letters and characters. I'm wondering if there's a way to handle formatting US zip as "00000-0000" (or "00000") while leaving the non-US zip unaffected?

My original plan was to create two dashboards - one for US, and one for international, but I figured I'd ask here. Any insight is greatly appreciated! Many thanks in advance for the time and help! 

Cheers,

Lele

[vicky_ · Accepted solution]

You could try add a calculated column: 
Formatted ZipCode = IF([CountryColumn] = "United States", format your zip code, [zip code])
As for how to format the US zip codes, you will probably need to use the RIGHT() or LEFT() functions to grab the right bits before and after the hyphen.

[leletran]

Hi Vicky,

Good morning! That worked - you are a genuis! Thank you so much for your time and help! 😁 

The formula: Formatted ZipCode = IF([RecipientCountry] = "United States", CONCATENATE(LEFT([Zip Code],5), CONCATENATE("-", RIGHT([Zip Code],4))), [Zip Code])

I hope this helps anyone that want to format US- and non-US zip! Thank you again, Vicky. Have a great rest of your morning and day!

Cheers,

Lele