Skip to main content

Sort and Filter Items

Narrow a project's items by status, Area, Schedule, Type and more, and sort them in Grid View or Spreadsheet View.

Written by Scottie Elliott

Filter a project's items to see only the ones you need, and sort them into a useful order. Grid View and Spreadsheet View each have their own controls. Filters and sorting are temporary: they're cleared when you reload the page or switch views.

Filter and Sort in Grid View

  1. Click Filters (the funnel icon) in the toolbar, then Open Filters.

  2. Check the values you want under Statuses, Areas, Schedules & Types, Product Tags or In Budget.

  3. (Optional) Choose a Sort By option.

  4. Click Apply.

Product Board Filters in Grid View, with Sort By on the right.

While a filter or sort is on, items show in one list instead of by Area. To go back to the normal board, click Clear Filters.

Filter in Spreadsheet View

  1. Under a column heading, click Search.

  2. Choose one or more values from the list. You can type to search the list.

  3. Add filters on other columns if you need them.

The Schedule filter in Spreadsheet View, with the total for filtered items at the top.

The total at the top changes to Total for Filtered Items, with the number of matching items. To remove every filter, click Clear All Filters in the toolbar.

To filter by In Budget, first show the In Budget column. It's hidden by default. See Show, Hide and Reorder Spreadsheet Columns. Then choose Yes or No in its filter.

For number columns such as Quantity, type a number, range or comparison, for example 3,10-15,>20, and press Enter.

Sort in Spreadsheet View

Click a column heading to sort A to Z. Click it again for Z to A, and a third time to turn sorting off. An arrow next to the heading shows the current order.

Good to Know

  • Grid sort options: Alphanumeric (A-Z), Date Added, Estimated Ship Date, Estimated Receive Date and Estimated Install Date. Archived Items shows archived items instead.

  • In Budget: choose Yes or No. In Grid View it's a group in Product Board Filters. In Spreadsheet View it's a column.

  • Statuses filter today's status: it can't find items that were approved in the past but have a different status now.

  • Schedules & Types: checking a Schedule includes all its Types. To narrow further, check only the Types you need.

  • Dragging: you can't drag cards in Grid View while a filter or sort is on.

  • Some columns can't be sorted: for example Product Tags and Ship To. Use their filter instead.

Troubleshooting

Problem

What to check

An item I expect is missing

Click Clear Filters (Grid View) or Clear All Filters (Spreadsheet View), then add filters back one at a time. Archived items only show with Show Archived Items on.

My filters disappeared

Filters clear when you reload the page or switch between Grid View and Spreadsheet View. Apply them again.

There's no Supplier filter in Grid View

Use the Supplier column filter in Spreadsheet View.

A number filter didn't match what I typed

Number filters ignore decimal points. A plain number such as 5 also matches 5 to 5.99.


Did this answer your question?