Flagging bad phone numbers

kolfinna
kolfinna ✭✭✭✭

Hello!

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.

Thanks!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!