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! 

 

Thanks!!!

 

Comments

  • 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...

    Thanks

  • @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 ✭✭✭✭

    Hi,

     

    Not ideal but might help.

    In the form use the "Help Text" see velow

    Phone no.PNG

This discussion has been closed.