How to Filter a List by a Column
Every column you can filter on the Calls list and the Customers list has a small funnel button at the right of its heading. It opens a filter for that column, so you can show, for example, only calls with a certain reference, or only customers in one group. The funnel shows when you point at the heading, and a column that is filtering keeps its funnel visible and filled in so you can always see it.
How do I filter a list by one of its columns?
Point at the column heading and click the funnel at its right-hand end, choose what to keep, then press Apply. The list goes back to page 1 and shows only the matching rows, and a chip on the filter line above the list says what the column is filtered to.
- Point at the column heading on the Calls list or the Customers list.
- Click the funnel button (its name is "Filter" and the column's name).
- Choose what to keep: tick values, type text, enter numbers or pick dates, depending on the column.
- Press Apply, or press Enter in a text box.
The funnel can also be reached without a mouse: press Tab to move through the headings' funnel buttons. The corner of the filter card says what kind of filter it is: List, Text, Number or Date, or Pick for a funnel that opens the customer search, and Status for the Customers list's Which accounts card. The Escape key, the Close button or a click anywhere else closes it without changing anything.
How do I filter by a list of values?
A List filter shows every value the column can hold, each with a tick box. Tick the ones you want and press Apply; ticking six values costs one reload of the list, not six.
- Select all and None tick or untick every value that is showing.
- When the list holds more than eight values, a search box appears at the top ("Search" and the column's name). Select all then ticks only the values the search is showing, not the ones it has hidden.
- The count beside the buttons, such as "3 selected", says how many you have ticked.
- A yes-or-no column offers Yes and No.
How do I filter by text?
A Text filter has one box. Type part of the value, choose Starts with or Contains, and press Apply or Enter. Upper and lower case are ignored.
Starts with is the faster of the two. When you choose Contains on the Calls list, the card warns that every call in the date window has to be read, which is fine on a month and slow on a year. On the Customers list the card says the whole customer list is checked, which is quick there. A column that holds a sentence, such as a note, can only be searched inside: its card has no Starts with, and says "This one holds a sentence, so it can only be searched inside."
How do I filter by a number or a date?
A Number filter has At least and At most. Fill in one or both, then press Apply. Leave either blank for an open end; rows with no value in the column drop out.
A Date filter offers presets: Today, This week, Last 7 days, This month, Last 30 days, This year, Last year and Custom. A preset applies the moment you click it and closes the card. Custom opens From and To date boxes, and then needs Apply. Both dates are included. Rows with no date in that column drop out.
On the Calls list, the Logged and Due funnels move the list's one date window rather than adding a second one; other date columns, such as Started or Ended, add a window of their own on top of it.
Note: A date column filter keeps the dates it worked out on the day you applied it. If you pick This month in the Started funnel and save that in a layout, the layout brings back that month's dates next month too, even though the chip still says "This month". Only the Calls list's own date window, set from the rail or the Logged and Due funnels, moves with the calendar. Pick the preset again to bring a column's dates up to date.
How do I change or remove a column filter?
Click the chip for that column on the filter line above the list to reopen its filter, holding what you last chose, or click the chip's × to remove it. Inside the card, Clear filter removes the filter; it is offered only while the column is filtering.
Removing the last tick from a list filter, or emptying a text box, removes the filter rather than leaving an empty one that would match nothing. Clear all filters on the filter line removes every filter at once.
Why do some column filters tick the filter rail?
Some columns are filtered by the same control as a list in the filter rail, so the funnel and the rail are two doors onto one filter. On the Calls list, ticking a value in the Type, Status, Action status or Engineer funnel ticks it in the rail as well. The Customer and Customer code funnels both open the same customer search as the rail's Customer block: picking a customer applies at once and shows only that customer's calls. The Invoice to and Invoice to code funnels open the same search for a second, separate filter, the customer the calls are invoiced to, so you can filter by both at once.
On the Customers list, the Status funnel is Which accounts, and the Group, Category and Account manager funnels are the rail's lists. The Name and Code funnels there are ordinary text filters; the customer search box on the Customers list's toolbar is a different thing that finds one customer.
Why can't I filter a column, or add another filter?
Some columns on the Calls list and the Customers list have no funnel at all, on purpose. The Calls list's Problem description and Resolution columns show only the start of the text, so a filter on them would quietly miss everything after that; rather than give answers that look complete and are not, those two columns cannot be filtered or sorted. To find calls by words in the problem description or the resolution, use the Search calls box on the Calls list's toolbar instead: type a word or phrase and press Enter, and it searches the whole text of both, inside the date window. A long-text custom field your company has added does have a funnel, but it only searches inside the text: it says "This one holds a sentence, so it can only be searched inside." On the Calls list, while Which calls is on To schedule, the Engineer, Action status, Due, Started and Ended columns cannot be filtered either, because calls nobody has been scheduled for have nothing in them, so a filter could only ever find nothing.
A list can have at most 10 column filters at once. When ten are on, the funnel of an eleventh column opens with the message "A question may filter at most 10 columns. Clear one to filter this." Remove a filter you no longer need, from its chip's × on the filter line, and try again. On the Calls list, ticks in the filter rail's lists and the picked customers do not count towards the ten. On the Customers list they do: the Group, Category and Account manager lists in the rail are column filters, so each one with ticks counts as one of the ten.