Views, filters & sorts

In this Article

You can view the same database in multiple ways, and switch back and forth between them depending on your needs in the moment. Within a view, you can add filters and sorts to easily categorize your content 📁


Views

There are six different ways to visualize your content within a database. Here's a high level overview of each!

Table view: This is the most traditional way of viewing a database. It allows you to see your dataset as rows of pages, with every property represented by a column.

Board view: This view groups your items by property. For example, use it as a Kanban board to move an item through phases of a process.

Timeline view: Use your database to plot projects on a timeline so you can visualize when they are taking place and how long you think they will take to complete.

Calendar view: Displays your items based on their Date property.

List view: A minimal, vertical layout of your items that lets you open them as a page with one click.

Gallery view: Use your database to display images. You can edit your gallery to show images contained in the Files & media property or content inside each page.

Create and edit views

Everything to do with views can be controlled from the dropdown at the top left of your database.

  • If you don't have any views yet, click the + Add view button at the top left. This becomes the dropdown menu where you can see, add and select views.

  • Give your view a name in the text box, and choose the type of view you want it to be.

Click the name of your current view to see a dropdown of all your existing views.

  • Click ••• to the right of any view to edit the type of view it is (table, board, gallery, etc.), rename it, Duplicate it, or Delete the view.

  • Re-order your list of views by dragging the ⋮⋮ icon next to any view up or down.

  • Click your view dropdown on the top left, then click the name of any other view to switch.

  • In your sidebar, views show up as nested items inside any full-page database. You can tell they are views because they'll have a  to their left.

  • Click on any view in your sidebar to jump right to it.

Filter

Notion makes it easy to filter your database so it only displays the items that meet specified criteria, i.e. have (or don't have) certain properties. These filters can be as simple or complex as you like!

Add a filter

To filter the entries you see in a database view:

  • Click Filter at the top right of your database (you'll find it inside the ••• next to the blue New button if it's an inline table)

  • Click Add a filter at the bottom left of the window that appears

  • Choose the property you'd like to filter by. In this example, we're filtering the Table view of our Roadmap so that all the entries have to meet the criteria Priority + Is + P1🔥.

Tip: If you find yourself recreating and deleting the same filters over and over again, consider creating a new database view for that filter. That way, you can switch back and forth without having to recreate the filter each time.

Add a filter group

You can create more specific database views and combine AND and OR logic by using filter groups. These can be nested up to three layers deep! Here's how:

  • Click Filter at the top right of your database (you'll find it inside the ••• next to the blue New button if it's an inline table).

  • Click Add a filter at the bottom left of the window that appears, then select Add a filter group in the dropdown.

  • In the example below, we're filtering the Table view of our Roadmap so that all the entries have to meet the criteria that include both AND and OR logic.

Tip: You can quickly turn a filter into a filter group by clicking the ••• to the right of the filter, and selecting Turn into group.

Sort

You can sort your database so that items are displayed based on properties appearing in ascending or descending order.

For example, you can order them based on priority, or last edited, or alphabetically.

  • Click Sort at the top right of your database, then + Add a sort.

  • Choose the property you want to sort by, and whether you want it Ascending or Descending. Your database will change immediately.

  • You can add as many sorts as you want, or remove them by clicking the X to their right.

  • Change the order that multiple sorts are applied by dragging them up or down using ⋮⋮.

Note: Different properties sort by different logic, depending on their value type.

  • Text properties such as Name and Text sort alphabetically.

  • Number properties sort numerically.

  • For Select and Multi-select properties, you get to define what sorting order means. Click on the property, then drag options up or down to set the sort order.


Give Feedback

Was this resource helpful?


Up Next

Tables

A table is the classic database view, but tables in Notion are more than just rows and columns. Each row opens up into its own page, and can contain whatever properties you want 📊