I want a column value to be valid only if its last two letters (case sensitive) are in a list.
The current formula is
IN(Right([_THIS],2), {“ha”})
It works, but it accepts both ha and Ha. I want only values that end with ha, and prevent entries that end with Ha
2 - Is substitute formula case-sensitive?
User | Count |
---|---|
17 | |
11 | |
7 | |
5 | |
5 |