← All articles

Reports & charts — Filter rows

Click + Filter (available once the report has at least one column) to add a rule: a column, an operator, and a value. Click Save filters to apply. Operators cover equality (=, ≠), text (contains), numeric comparisons (>, <, ≥, ≤), and blank checks (is empty, is not empty — these need no value, so the value box greys out). For date columns, in last … days and in next … days take a number of days and match a rolling window that includes today. With more than one filter, a Match selector appears: all keeps rows that pass every rule; any keeps rows that pass at least one. Filters run in the database wherever they can, so a filtered report reads the whole table rather than a slice of it. A filter that reaches through a lookup, a rollup or a formula can't be run there — those values are computed while the report is being built, so they don't exist yet — and a report using one falls back to the first 20,000 records and says so at the top. If you hit that, filtering on a stored field instead removes the limit.
Nothing here answered it? Ask us directly — we usually reply within one working day.

Made with RowFold