Phone Number formatting
Is there a way to format phone numbers in SmartSheet. For example - I have about 400 phone numbers and the format is in different formats - 555-555-5555 or (555) 555-5555.
Is there a formula or an option within SmartSheet that I am missing?
Best Answers
-
You can do that with a giant combinations of SUBSTITUTE( to get replace with blanks any/all characters that aren't numbers (like =SUBSTITUTE([Old Phone #]@row, "-", "") ) to make a helper column. Then with a combination of LEFT(, MID(, and RIGHT( to add in the formatting of your liking (like =LEFT([New Phone #]@row, 3) + "-" ...etc, where [New Phone #] would be your column with all the odd characters subbed out).
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
-
Thanks Jason! Appreciate the information
Answers
-
You can do that with a giant combinations of SUBSTITUTE( to get replace with blanks any/all characters that aren't numbers (like =SUBSTITUTE([Old Phone #]@row, "-", "") ) to make a helper column. Then with a combination of LEFT(, MID(, and RIGHT( to add in the formatting of your liking (like =LEFT([New Phone #]@row, 3) + "-" ...etc, where [New Phone #] would be your column with all the odd characters subbed out).
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
-
Thanks Jason! Appreciate the information
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives