Filter rows
Filters are pretty useful to keep and display only the rows that you care about. They lets you define rules to ignore rows.
Examples:
Keep only the rows edited today or this last 3 days
Remove the rows containing empty cells
Use only rows that contains a specific value
You will find the filters in the bottom part of “Chart data”
The filters aims to hide rows, each rule will define which ones to hide.
Pick a column to be used as filter
Its type matters, you won’t have access to the same filters depending on it. For example, only column of type number or formula can be filter by “is over”. Learn more about types here: Deal with Column types (Property)
Pick a filter
Last be not least, define the parameter of the filter. It will be necessary for all filters but is empty or is not empty
Applying a filter lets keep ALL rows but the ones that matches the filter. For example:
Examples:
Keep only the rows edited today or this last 3 days
Remove the rows containing empty cells
Use only rows that contains a specific value
How to create a filter?
You will find the filters in the bottom part of “Chart data”
The filters aims to hide rows, each rule will define which ones to hide.
Pick a column to be used as filter
Its type matters, you won’t have access to the same filters depending on it. For example, only column of type number or formula can be filter by “is over”. Learn more about types here: Deal with Column types (Property)
Pick a filter
| Filter name | Description |
|---|---|
| is empty | cell empty |
| is not empty | cell has a value |
| is equal to | cell is equal to an exact parameter |
| is not equal to | cell is anything but a parameter |
| contains | does the value contain the parameter |
| does not contain | does the value not contain the parameter |
| is over | strictly over a specified parameter (only for quantitative types) |
| is under | strictly under a specified parameter (only for quantitative types) |
| is before | if a date is before the parameter (only for date type) |
| is after | if a date is before the parameter (only for date type) |
| is … days before | if a date is N days before today - N as parameter (only for date type) |
| is … days after | if a date is N days after today - N as parameter (only for date type) |
| is not current… | if a date during the current day, week, month or year |
Last be not least, define the parameter of the filter. It will be necessary for all filters but is empty or is not empty
Applying a filter lets keep ALL rows but the ones that matches the filter. For example:
| Column value | Filter | Parameter | ⇒ Result |
|---|---|---|---|
| 10, 34, 12 | is over | 20 | 10, 12 |
| tomato, peas, chickpeas | contains | peas | tomato |
| 8 Oct 2021, 10 Dec 2021 | is before | 1 Dec 2021 | 10 Dec 2021 |
Examples
Updated on: 18/06/2023
Thank you!