I've been required to use the formula-based "not equal" condition (for {if} statement) instead of a built-in operator (like != in most languages). I tried !, !=, and not, but none of them worked.
Two suggestions to improve this:
- When a user types
!=(the most intuitive option for many of us), show a hint or autocomplete suggestion explaining the correct way to express "not equal" in the formula. - Alternatively (or additionally), add a clearly visible "Not equal" button or option in the UI (e.g. into formula submenu) so users can apply this condition without guessing the correct syntax.