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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives