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 |
---|---|
31 | |
13 | |
3 | |
3 | |
2 |