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 |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |