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! Go to Solution.
IFS([Country] = "XXXX", AND(LEN([_THIS]) = 9, STARTSWITH([_THIS], "0"))
User | Count |
---|---|
18 | |
11 | |
11 | |
8 | |
4 |