Operators reference

Conditional formatting supports a broad set of operators that work on text, numbers, and dates. Pick the operator that matches what you’re checking — exact match, range, empty, recent, or set membership.

This page lists every operator the evaluator supports and what value each one expects.

Text and equality operators

Operator	Needs a value	What it matches
Equals	Yes	Field value equals your input (case-insensitive).
Not equals	Yes	Field value does not equal your input.
Contains	Yes	Field value contains your input as a substring (case-insensitive).
Does not contain	Yes	Field value does not contain the substring.
Is empty	No	Field is null, undefined, or an empty string.
Is not empty	No	Field has any non-empty value.

Use these for statuses, labels, priority names, assignees, and text fields. Case does not matter.

Numeric operators

Operator	Needs a value	What it matches
Greater than	Yes	Numeric value strictly greater than your input.
Greater than or equal to	Yes	Numeric value ≥ input.
Less than	Yes	Numeric value strictly less than input.
Less than or equal to	Yes	Numeric value ≤ input.
Between	Two values	Numeric value falls within `[low, high]` inclusive.

Use for Story Points, counts, custom numeric fields. Non-numeric values never match numeric operators.

Date operators

Operator	Needs a value	What it matches
Today	No	Field is exactly today’s date.
In the past	No	Field is before today. Great for “overdue”.
Before	Yes (date)	Field is strictly before the given date.
After	Yes (date)	Field is strictly after the given date.
In the next N days	Yes (number)	Field is between today and today+N inclusive.
In the last N days	Yes (number)	Field is between today−N and today (excluding today).

Dates are compared at local midnight, so YYYY-MM-DD values never drift across time zones.

Set operators

Operator	Needs a value	What it matches
Is one of	List of values	Field equals any value in your list.
Is none of	List of values	Field equals none of the values in your list.

Useful for grouping several statuses into a single rule (e.g., “Blocked” or “Waiting” or “Needs info” all paint amber).

Which operators show in the dialog

The Configure Formatting dialog currently exposes Equals, Not equals, Contains, Greater/Less variants, Between, Is empty/not empty, Today, In the past, In the next N days, and In the last N days. The remaining operators (Before, After, Is one of, Is none of, Does not contain) are supported by the engine and reachable via programmatic rules; they will appear in the dialog in a future iteration.

Tips

Use Contains instead of Equals for labels where an issue may have many values.
Combine In the past (overdue) with Is not empty (has a due date) to avoid false positives on dateless rows.
Between expects two numbers; if either is missing, the rule never matches.