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
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!