Phone Column Type accepting character

[EugeneB]

Does anyone notice that the phone column type accepting letters? what is the best way to validate phone number field to prevent all the letters, or symbols.

[Suvrutt_Gurjar · Accepted solution]

Does the following validation in the valid_if help for a 10 digit phone number entered as continuous string of 10 digits.

AND(NUMBER([_THIS])>=1000000000, LEN([_THIS])=10)

[EugeneB]

@Suvrutt_Gurjar this is simply genius.

[TotalSolutions]

I want the same result but the number is an extension so it can be anywhere between single to 4 digits please let me know how to do this.

Thank you!!

[Suvrutt_Gurjar]

Could you update if you have tried any expressions?

[TotalSolutions]

Suvrutt_Gurjar:

AND(NUMBER([_THIS])>=1000000000, LEN([_THIS])=10)

This works for 10 digit mobile numbers but I have number which is an extension number so it can be anywhere between single to 4 digits what will be the expression in that case?

please let me know.

[Suvrutt_Gurjar]

Maybe

AND(NUMBER([_THIS])>0, LEN([_THIS])<=4)