Add a filter to a worksheet

You can add filters to a Worksheet to limit the data it contains. This is useful when you have underlying tables that store more data than is necessary for the types of analyses the Worksheet is intended for. You can also use Worksheet filters to provide data security, when you want different groups of users to be able to see different data without relying on row level security.

Worksheet filters are ignored by the search index. As a result, when searching a worksheet, you will get suggestions for things even when they are filtered out.

To add a filter to a Worksheet through the user interface:

  1. Click Data in the top menu bar, find your Worksheet, and click its name.

  2. Click the Edit Worksheet button.

    Edit a worksheet
  3. Hover over Filters on the left menu and click +.

    Add a worksheet filter
  4. Choose the column you want to filter on.

    Choose a worksheet column to filter on
  5. Select the values to include in your answer.

    Specify values to include
  6. If you want to exclude values, click Exclude and choose values to exclude.

  7. Click Done.

    If there are too many values, you can use the filter search bar to find the ones you want.

Was this page helpful?