Phone Number Format


Hi. I've trolled through pretty much every thread regarding this topic and I found a formula that works, except where it's not supposed to. I'm using this formula in a secondary cell/ column to format phone numbers in another column using parentheses and dashes. The problem I'm having is the formula converts the phone number in the cell/ column where the formula is and not where the phone number digits are stored. Please help, this is driving me crazy!!

="(" + LEFT([Contact Number]1, 3) + ") " + MID([Contact Number]1, 4, 3) + "-" + RIGHT([Contact Number]1, 4)




  • Maaik Meijerink
    Maaik Meijerink ✭✭✭✭✭


    It seems you want to change the cells in the column with the actuals numbers in it. If this is the case: it is not possible: you can only let the formula work based upon the other column, not within the source-column itself (where the original phone nu,mber digits are stored).

    If you realy want this, you should use an API for solving your request.

    If however misunderstood, please let me/community know.

    Grtz, Maaik

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!