Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Column Formatting of Zip Codes, Phone Numbers

Pam L
Pam L ✭✭
edited 12/09/19 in Archived 2015 Posts

I'd like to be able to choose a preformatted Zip Code column type, as well as a preformatted phone number column type.  


Currently, any Zip Codes that start with "0" (as in, the entire New England region) get messed up in that column - because "zero" isn't recognized as an initial number (so - it wouldn't have to be a zip code specific column type, just one that recognizes "0" can legitimately start a series of numbers!).  The work around has been either to add a dash "-" after the affected zip codes, or do a look-up and add the Zip+4...


A (xxx) xxx-xxxx formatted column would be really great for North American telephone numbers! 





This discussion has been closed.