Filter, Sort, Group
Filters, sorting, grouping, row colors, and frozen columns are view-specific: you can set up different configurations for each view without affecting any other view.
Filtering
Section titled “Filtering”Filters show only entries that meet certain conditions.
Adding a filter
Section titled “Adding a filter”- Click Filter in the top-right corner
- + Add filter
- Choose column → operator → value
AND / OR logic
Section titled “AND / OR logic”Several values in one rule
Section titled “Several values in one rule”For select, multi-select, relation and person there are is any of and is none of: tick the values in a list. Instead of “Category is Purchase” OR “Category is Purchase costs”, one rule does it. While nothing is ticked, the rule filters nothing out.
Multiple filters default to AND logic. Between any two filter rows an AND / OR pill appears — click it to switch all filters to OR. The logic applies globally to all filters in this view — and since August 2026 in every view, not just the table.
Available operators by type
Section titled “Available operators by type”| Column type | Operators |
|---|---|
| Text / URL / Email | contains, does not contain, is, is not, is empty, is not empty |
| Number / Rollup | =, ≠, >, <, ≥, ≤, is empty, is not empty |
| Date | is, before, after, is empty, is not empty |
| Select | is, is not, is empty, is not empty |
| Multi-Select | contains, does not contain, is empty, is not empty |
| Checkbox | checked, not checked |
| Relation | linked, not linked |
| Select / Multi-select / Relation / Person | additionally is any of and is none of — several values in one rule |
| Formula / Lookup | contains, does not contain, =, ≠, >, <, ≥, ≤, is empty, is not empty |
| Count / Auto-number / Duration | =, ≠, >, <, ≥, ≤ |
| Created at / Modified at | today, this week, this month, past, future, before, after, between |
| Created by / Modified by / Person | is, is not, contains, is empty, is not empty |
Computed columns (Formula, Rollup, Lookup, Count) can be filtered and sorted since August 2026: their value is resolved before filtering. Only the backlink stays out — it has no value of its own in the row.
Sorting
Section titled “Sorting”Sort rows ascending or descending by one or more columns. Multiple sort rules are applied in order — the first rule takes priority.
Adding a sort
Section titled “Adding a sort”- Click Sort
- Choose column and direction (ascending / descending)
- + Add sort for a secondary level
Grouping
Section titled “Grouping”Grouping organises rows by a column — as sections in the table or as columns in Kanban.
Supported column types for grouping
Section titled “Supported column types for grouping”Every column except File, Image and Button. That includes Relation (labelled with the linked row’s title), Person (by name), Location, Duration and the computed columns Formula, Rollup, Lookup and Count.
In Kanban the choice is narrower: Select, Checkbox and Person — only those three can take back the new value when a card is moved.
Enabling grouping
Section titled “Enabling grouping”Click Group → choose a column. Each group shows the entry count and can be collapsed or expanded.
Hiding columns
Section titled “Hiding columns”In table view you can hide columns without deleting them:
- Click Fields
- Deactivate the columns you want to hide
Hidden columns remain visible and editable in the row detail view.
Freeze columns
Section titled “Freeze columns”Frozen columns stay pinned on the left while you scroll horizontally — useful when you have many columns and always want the name or first column visible.
Freezing a column
Section titled “Freezing a column”- Click the column header of the column up to which everything should be frozen
- Choose Freeze column
- All columns from the first up to and including this one are pinned
To unfreeze, click the frozen column header → Unfreeze.
Row colors
Section titled “Row colors”Row colors highlight specific rows — based on conditions you define (e.g. mark all rows with status “Urgent” in red).
Setting up color rules
Section titled “Setting up color rules”- Click Color in the toolbar
- + Add color rule
- Choose column → operator → value → color
Multiple rules are evaluated in order — the first matching rule determines the row’s color.
Table search (⌘F)
Section titled “Table search (⌘F)”Press ⌘F (Mac) or Ctrl+F (Windows/Linux) to jump directly into the table search field. The table filters all rows that contain the search term in any cell — without saving a filter.
Aggregations (Column Footer)
Section titled “Aggregations (Column Footer)”The table view has an aggregation row at the bottom — below the last data row, marked with a ∑ symbol on the left.
Setting up an aggregation
Section titled “Setting up an aggregation”Click any cell in the aggregation row to open the menu. Choose the desired aggregation — the value is calculated and displayed immediately.
Available aggregations by column type
Section titled “Available aggregations by column type”| Aggregation | Description | Available for |
|---|---|---|
| None | Disable aggregation | all |
| Count | Total number of rows | all |
| Empty | Number of empty cells | all |
| Not empty | Number of filled cells | all |
| Unique values | Count of distinct entries | all |
| Sum | Sum of all numeric values | Number, Formula, Rollup, Rating, Auto-number |
| Average | Arithmetic mean | Number, Formula, Rollup, Rating |
| Min | Smallest value | Number, Formula, Rollup, Rating |
| Max | Largest value | Number, Formula, Rollup, Rating |
| Earliest date | Earliest date | Date, Created at, Modified at |
| Latest date | Most recent date | Date, Created at, Modified at |
| Checked | Number of ticked checkboxes | Checkbox |
| Unchecked | Number of empty checkboxes | Checkbox |
| % Checked | Percentage of ticked boxes | Checkbox |
Formatting
Section titled “Formatting”Aggregation values for number and formula columns are displayed using the configured column format (currency, percent, decimal places).
Persistence
Section titled “Persistence”Aggregation settings are saved per view — each view can have its own aggregations, and they persist after reloading.
Multi-Select & Bulk Edit
Section titled “Multi-Select & Bulk Edit”In the table view you can select multiple rows and edit them at once.
Selecting rows
Section titled “Selecting rows”- Click the checkbox at the far left of a row
- Select all: Click the checkbox in the column header
Bulk editing
Section titled “Bulk editing”When rows are selected, a floating action bar appears at the bottom of the screen:
-
Choose a column from the dropdown
-
Set the new value — the input matches the column type:
Column type Input Select list of options, coloured as in the table Multi-select options to tick and untick Checkbox two buttons: Yes / No Date, Time date resp. time picker Person list of members Relation searchable list of entries Number, Rating, Duration number field Text and relatives text field Every picker offers Clear field at the bottom — for removing a value across many rows at once.
-
Click Apply — all selected rows are updated
Computed columns (Formula, Rollup, Lookup, Count) are not offered: they cannot be written to.
Bulk delete
Section titled “Bulk delete”Click Delete in the action bar → confirm the dialog. All selected rows are permanently deleted.
Resetting a view
Section titled “Resetting a view”Click Filter / Sort / Fields → Reset to restore all configurations of a view to their defaults.