How to autopopulate phone numbers?
I would like to format all input numbers to have the same format (xxx) xxx-xxxx
Answers
-
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
-
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.
-
HERE is a link to the thread I mentioned before where we found a solution to take variable formats and standardize them.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 358 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!