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")`

.