Example image
Why is Sheet Gurus not accepting the phone numbers in my google sheet?

The probably cause here is that the formatting is incorrect -- please input the 10 digit phone number with no parens or dashes. 

Here is a formula that can help you change from parens and dash to 10 digit - =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"(",""),")","")," ",""),"-","") - just reference the correct cell!