Phone number Cell Format like Excel phone number cell Format
I can not for the life of me find where I can format cells for Phone numbers like excel. I'm having people enter in their info via a form and the phone numbers are causing immense discrepancies. Is there a way to format a column for phone numbers or selection on a form for phone number like there is for a date?
Best Answer

You should not "prefill" the formulas into rows. Getting the sheet started, you will need to insert a couple of rows with the formulas in them, but once there are two rows above the new entry that contain the formulas, autofill will pull the formulas down as new rows are submitted.
The form actually skips to the first row AFTER the last formula. It only appears that it is skipping to the last row because autofill is grabbing it.
Answers

There is not a built in format for it, but I recently helped someone with a similar solution. Let me dig through my notes and see if I can find the thread.

Take a look at THIS THREAD and see if maybe we can make this solution work for you.

Will this miss up the spreadsheet once a form inputs data from a user? I've notice if you place formulas in sheets where forms upload to they skip rows until the last row where the formula is located. Is there a way to prevent this? Right now I'm copying and pasting to excel to use their phone number cell format.

You should not "prefill" the formulas into rows. Getting the sheet started, you will need to insert a couple of rows with the formulas in them, but once there are two rows above the new entry that contain the formulas, autofill will pull the formulas down as new rows are submitted.
The form actually skips to the first row AFTER the last formula. It only appears that it is skipping to the last row because autofill is grabbing it.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!