Skip to content

Documentation › Tools › Calc

Views and filters

You can filter and sort a table to see only what you need, and create several views of the same data.

Filter a column:

  1. Open the menu in the column header and select Filter Data.
  2. Untick the values you do not want to see, or click None and tick only the values you do want. The table updates as you go.
  3. Click Close to close the box.

The filter is pinned as a button above the table. You can filter on several columns at once, in which case only the rows matching all filters are shown.

Sort a column:

  1. Open the menu in the column header and select Sort.
  2. Choose ascending or descending order.
  3. To sort on several columns, open the menu in the next column and select Add to sort.

Sorting and filters only affect your own view until you save them. Click Sort and filter above the table and choose Save if everyone with access to the document should see the same setting.

Create a new view:

  1. Click Add new in the left panel.
  2. Choose Add page for a new page, or Add widget to page to place a view alongside an existing one.
  3. Choose a type: Table, Card, Card List, Form, Chart, Calendar or Custom.
  4. Choose which table the view should draw its data from, and confirm.

Views show the same data but have their own sorting and filter settings. You can have one page showing confirmed sign-ups and another showing the pending ones.

Built on Grist: Manual, Forum, CC BY-SA 4.0