Phone Number Formatting Formula?


Is there a formula that will convert manually entered phone numbers to conform to the following format? The phone numbers are currently being entered in every different format imaginable.

Desired format...  (xxx) xxx-xxxx

Best Answer


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    There isn't a single direct formula that will do it, but you can parse out the field so that each character is in it's own cell then pick and choose what gets joined back together and how.

  • Good morning Paul, do you have an example of what that formula might look like? Also, could the individual cells in which the phone number would be parsed be on a separate sheet, so as not to be distracting?

  • Thank you Paul! That did the trick!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!