Column Properties

How can I set up a column to capture data such as a phone number with xxx (xxx) xxxx xxxx format for Country Code, Area Code and phone number. With dafualt County Code of where there data is coming from or with a default value that can be over-wrtitten by submitter

Find more posts tagged with

Sheets

Comments

L_123

If you are talking about using web forms you could use a concatenation to create a final column, and just use a default value in the web form. the concatenation would look something like this:

="("+[Primary Column]1 + ") " + [Column2]1 + " " + [Column3]1 + " " + [Column4]1

that way each column would be updated independently and put together in the 5th column

Shaine Greenwood

Hi Lawrence, if you don't want to have the submitter parse a phone number out into separate fields, you might consider using the LEFT and MID functions in your formula:

="(" + LEFT([Phone Number]1, 3) + ") " + MID([Phone Number]1, 4, 3) + "-" + MID([Phone Number]1, 7, 4)

Lawrence Liu

Thank you Luke & Shanie

But what I wanted in the web form layouts is to show up as

e.g. Phone - xxx (xxx) xxxx xxxx

As a guided field to those entering the form. I do not like to have the form verticular format I prefer it as a line as the above

e.g.

Country Code xxx

City code xxx

Phone number xxxxxxxx

That is not appealing.

L_123

In that case you could use a query string for the web form. I'm not to familiar with the topic as I haven't used it myself, but I plan to soon. Here is a help document on the topic.

https://www.smartsheet.com/blog/query-string-quick-guide