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

edited 12/09/19 in Archived 2015 Posts
05/28/15 Edited 12/09/19

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! 





  • JamesRJamesR ✭✭✭✭

    Start the entry with an apostraphy, this will treat the del as text.

  • Interesting work around, thanks for that!  however, we export/publish our member contact data onto our website, and that would likely stick out format-wise...

  • TravisTravis Employee
    edited 05/28/15

    Using a Contact List column instead of a Text/Number column will format the numbers as text (without an apostrophe) and will not strip out zeros. 

  • JamesRJamesR ✭✭✭✭
    edited 05/29/15

    interesting, was not aware of that. Thanks Travis.

  • It is a work around, though not an ideal one - b/c Contact List formatting creates a drop down linked to all "My Smartsheet Contacts", as you know.  I'm glad column formatting can be overwritten (e.g., same with Date column formatting can be overwritten with text), though...


  • @Pam L


    Did you determine a good way to format the telephone number that is entered from a webform?


  • I wish! I've just worked around it in the meantime.  I'm wondering if there is a format formula that could be copied/applied from Excel, though?  

  • JamesRJamesR ✭✭✭✭



    Not ideal but might help.

    In the form use the "Help Text" see velow

    Phone no.PNG

This discussion has been closed.