Filters keep only the rows you need, such as orders from last month or a single SKU. You can add as many filters as you like, and choose whether rows must match all of them or any of them.
Add a filter
Each filter is one row. To remove one later, select the trash icon at the end of its row.
Under Filters, select Add filter.
Choose a field, such as Order date or SKU.
Choose a condition, such as is or greater than.
Enter or choose the value.
Match all filters or any filter
When you have two or more filters, choose how they combine next to Add filter:
All: A row must match every filter. Use it to narrow results, such as last month's orders for one SKU.
Any: A row only needs to match one filter. Use it to combine groups, such as orders from either of two sales channels.
Conditions by field type
The conditions you see depend on the field.
Field type | Conditions |
Text, such as SKU or Product | is, is not, is any of, is none of, contains, starts with |
Numbers, such as Net sales or Quantity | equals, is not, greater than, at least, less than, at most, between, is any of |
Dates, such as Order date | in (a preset like Last 30 days), on, before, after, between, in the last |
Yes or no fields | is |
Most fields also offer is empty and is not empty.
How matching works
contains and starts with: Ignore capital letters, so "shirt" matches "Shirt" and "T-SHIRT".
is and is any of: Match the exact value, including capital letters.
Lists: For is any of and is none of, separate values with commas.
is not and is none of: Also keep rows where the field is empty.
between: Includes both end values.
Dates: Use your store's time zone, so "on October 1" means October 1 where your store is.
Date filters
Date fields start on in with Last 30 days, the most common filter. in the last lets you set your own window, such as 14 days or 6 months. Date ranges and presets lists every preset and exactly which days each one covers.
If no rows match
If your filters match nothing, the pane shows No rows match these filters and writes nothing to your sheet. Loosen a filter, switch All to Any, or check the value for a typo.