Valid If depending on the value of another field

In the same table I have a field called COUNTRY and another called CELL_NUMBER.
Only in the case that the country is "XXXX" I want to validate that the cell phone number meets the following conditions:

- The length must be 9 characters
- Must start with 0

Could someone give me a hand with this?

Solved Solved
0 4 1,271
1 ACCEPTED SOLUTION

IFS([Country] = "XXXX", AND(LEN([_THIS]) = 9, STARTSWITH([_THIS], "0"))

View solution in original post

4 REPLIES 4
Top Labels in this Space