Filter and Sort

You can easily filter and sort large, dynamic datasets in Row Zero. You can also apply multiple filters and sorts at the same time. Filtering and sorting in Row Zero is similar to Excel, Google Sheets, and other spreadsheets.

Apply filters and sorts to a range

To apply filters and sorts to a range, select the cells you'd like to filter and go to Data in the header menu and select Filter. apply filters in spreadsheet

Click the toggle in a column header to sort or filter that column. sort filtered range in spreadsheet

Filter

You can apply filters using an evaluation (e.g. greater than 5) or selecting specific values with categorical filtering. filter greater than in spreadsheet

Here are the available filtering options:

  • Filter text columns by:
    • is one of
    • contains
    • does not contain
    • starts with
    • ends with
    • is
    • is not
  • Filter number columns by:
    • is one of
    • equal to
    • not equal to
    • greater than
    • greater than or equal to
    • less than
    • less than or equal to
  • Filter date columns by:
    • is exactly
    • is after
    • is on or after
    • is before

With categorical filtering, you can search for specific values and select one or many values to filter on. categorical filtering in spreadsheet

Applying multiple filters

You can apply multiple filters to the same column and also apply filters to multiple columns at the same time. To apply multiple filters to the same column, click the filter icon in the column header and then click + Add filter in the bottom right of the filter dialog to add multiple filters. apply multiple filters in column in spreadsheet

To apply filters to multiple columns, simply navigate to each column and apply filters. Multiple filters are treated as "and" logic, so the sheet will filter to only rows that match all filters.

Convert filter to a conditional format

You can easily make a conditional format from a filter by clicking Make Conditional Format in the filter dialog. convert filter to conditional format in spreadsheet This will open the conditonal formatting window with the filter pre-set. Apply formatting and then optionally go back and clear the filter to see the unfiltered data with the previous filter now a conditonal format.

Clearing and removing filters

To clear filters, click on the filter icon in the column header and click Clear filters in the bottom left of the filter dialog. clear filters in column in spreadsheet

To remove all filters from a range, go to Data in the header menu and select Remove filtered range.

Note that you can only apply filters to one cell range at a time in a sheet. If you want to have multiple filtered datasets on one sheet, use data tables.

Sort

There are two ways to sort cell ranges in Row Zero: 1. via the filter dialog as outlined above or 2. via the Sort dialog which can be accessed by going to Data in the header menu and selecting Sort or by right-clicking on selected data and selecting Sort range sort multiple columns in spreadsheet You can easily sort mutiple columns at once and sorting respects filters applied.

Filter and sort data tables

Connected tables and pivot tables in Row Zero are represented as data tables, which are a convenient way to explore and transform large, dynamic datasets. You can filter and sort data tables that same way you filter and sort cell ranges, with a few differences:

  • Data tables are always ready to be filtered. Just click the toggle in the header column to filter or sort. You can also right-click in the data table and select Sort or Filter.
  • Data table filters and sorts are dynamic:
    • When source data updates the data table with new data, the filters and sorts are still applied.
    • When you filter and sort your data table, those filters and sorts are also applied to pivot tables and charts referencing the data table. filtering table also filters pivot table and chart
    • You can use the tilde operator "~" in formulas that reference data tables to also have formulas filter in sync with data table filtering (see screenshot below). The ~ is added right before the data table reference in the formula. dynamically filter formulas in spreadsheet The tilde can be added and removed from a function using F4 in formula edit mode.