How to autopopulate phone numbers?

Kayla Gaynor

I would like to format all input numbers to have the same format (xxx) xxx-xxxx

David Tutwiler

Will all the numbers come in as plain text? If so you can build it as this string (primary column being the column the number resides):

="(" + LEFT([Primary Column]1, 3) + ") " + MID([Primary Column]1, 4, 3) + "-" + RIGHT([Primary Column]1, 4)

If not, you'll likely have to go through multiple rounds of the =SUBSTITUTE function to get rid of extra characters ()-.

There is also already a thread with this, for reference. https://community.smartsheet.com/discussion/5542/auto-format-phone-number

Paul Newcome

There was another thread from a while back that included a solution for variable formats being entered so that the user could standardize everything. I'll see if I can find it, but the general idea was that we ended up using helper columns to parse out each digit then pulled it back together ignoring what we wanted to remove and inserting the various symbols.

Paul Newcome

HERE is a link to the thread I mentioned before where we found a solution to take variable formats and standardize them.