Phone Column Type accepting character

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.

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)

3 Likes

@Suvrutt_Gurjar this is simply genius.

1 Like