Formula Operators Cheat Sheet

While some locations (such as the Create/Edit Saved Search wizard) automatically add operators into your formulas, other locations (such as print templates and Variable Formula fields) rely on you to manually add them.

Because formulas provide so much flexibility to the system, I figured it might be helpful for folks to have a cheat sheet of the operators available when creating formulas.

Symbol Operator Function Operator Name
== Equals OPERATOR_EQUAL
!= Does not equal OPERATOR_DIFFERENT
>= Is greater than or equal to OPERATOR_GREATER_OR_EQUAL
<= Is less than or equal to OPERATOR_LESS_OR_EQUAL
> Is greater than OPERATOR_GREATER
< Is less than OPERATOR_LESS
&& And OPERATOR_LOGICAL_AND
~= Contains OPERATOR_CONTAINS
% Remainder OPERATOR_REMAINDER
! Not true OPERATOR_LOGICAL_NOT

Note that the Not true (!) operator can be placed in front of any other condition to negate it. For example, imagine that you want your formula to check whether the Related to field does not contain a value of “Contract.” To do this, your formula would read !($related_to~= "Contract").