Flagging bad phone numbers
I've been reading around and I feel like I'm missing something with my formula:
=IF(OR(NOT(ISNUMBER([Phone Number]@row))), [Phone Number]@row < 1000000000, [Phone Number]@row > 9999999999, 1, "")
Basically, I want a checkbox to tick if any of the following happens:
- Any characters are added
- It has fewer than 10 digits
- It has more than 10 digits
Feels like I'm missing something super easy with this formula. But--it looks like the format is right? I was looking at this post for guidance:
What am I missing?
Also--does Smartsheet have any plans for data validation? That could be fantastic for forms when people input bad information.
Help Article Resources
Check out the Formula Handbook template!