🔎 Lesson 3.4: Filters, Sorts & Grouping: Seeing Only What Matters

One Database, Many Lenses

In the last lesson you learned that a database can be shown as a table, a board, a calendar, a gallery, a list, or a timeline. That's how the rows are laid out. This lesson is about which rows show up and in what order — the three controls that live on every single view:

• Filter — the bouncer at the door. Only rows that meet your conditions get in.
• Sort — the usher. It decides the order rows appear in once they're inside.
• Group — the seating chart. It clusters rows into sections (or board columns) by a shared property.

Here's the idea that makes all of this click: these settings belong to the view, not to the data. You can create ten views of the same database, each with different filters and sorts, and no row is ever copied or moved. Edit a task once and every view updates. That's why a "Today" screen and a "Completed" screen can live side by side without you managing two lists.

Filters: Show Only What Matters

A filter is a rule: "only show rows where ___ is ___." To add one, open a view, click Filter in the view's toolbar (the row of controls above the table), pick a property, and choose a condition. Notion hides everything that doesn't match — instantly, and only in that view.

Say your tasks database looks like this:

Add a single filter Status is not Done and the "Draft newsletter" row quietly disappears from this view (it's still safe in the database — just hidden here). Add Due is today instead and you're left with only the first two rows. That's the whole trick: describe what you want to see, and Notion does the hiding.

Common filter conditions by property type

The available conditions change to fit the property you pick — dates get date operators, checkboxes get checked/unchecked, and so on:

Compound Filters & Operators

One condition is often enough, but the magic happens when you combine them. Notion lets you join filters with AND (every condition must be true) or OR (any condition can be true), and you can nest them into filter groups for more precise logic.

AND — narrow it down

A "Today" view usually wants two things at once: due today and not finished. That's an AND:

Due  is  Today
  AND
Status  is not  Done

Both must be true for a row to appear. Add a third with AND and you narrow further — AND Priority is High gives you a "what must I do first today" view.

OR — widen it out

Sometimes you want rows that match any of several conditions. An "urgent radar" might be:

Priority  is  High
  OR
Due  is before  Tomorrow

Now anything high-priority or overdue shows up, even if only one condition is true.

Filter groups — combine AND with OR

Real questions mix both. "Show me tasks that are overdue, plus anything high priority due this week." To express that cleanly you wrap conditions in a group so the logic stays unambiguous:

( Due  is before  Today )
  OR
( Priority  is  High   AND   Due  is within  the next week )

In Notion you build this by adding filters and then choosing + Add filter group. Each group has its own AND/OR toggle, and the groups themselves are joined by AND/OR. It reads exactly like the parentheses above.

Sorts: Control the Order

Once the right rows are in, sort decides their order. Click Sort in the view toolbar, pick a property, and choose ascending or descending. Like filters, a sort belongs to the view — your "Today" view can sort by priority while your "Completed" view sorts by the date you finished.

Multi-level sorts

You can stack sorts, and order matters: Notion applies the first sort, then breaks ties with the second, and so on. A great task ordering is:

1. Priority   Descending   (High → Low)
2. Due        Ascending    (soonest first)

That reads as: "Show my high-priority tasks first; within the same priority, put the soonest due date on top." Drag the sort rules to reorder them — the top rule wins.

Grouping & Sub-Grouping

Grouping clusters your rows into sections by a shared property. On a board view, the group is the columns — group by Status and you get "Not started / In progress / Done" lanes you can drag cards between. On a table or list, grouping adds collapsible section headers with a count on each.

Here's the same tasks database as a board grouped by Status:

On a real board these three groups sit side by side as columns. Drag a card from "Not started" to "In progress" and Notion changes that row's Status property for you — grouping and editing are the same gesture.

Sub-grouping

On board views you can add a second level: group by Status and sub-group by Priority, giving you priority bands inside each status column. It's powerful, but use it sparingly — too many sub-groups turns a clean board into a spreadsheet maze. One level of grouping serves 90% of needs.

Group vs. Filter — what's the difference?

They're easy to confuse: both organize by a property. The difference is that filtering removes rows you don't want to see, while grouping keeps everything and just sorts it into labelled buckets. You often use both together: filter to "not archived," then group by Status.

Search Within a Database

Filters are for durable, reusable lenses. When you just need to find one thing right now, use Search instead. In a table view, click the 🔍 icon in the view toolbar (or press / in the search box) and type — Notion instantly narrows the visible rows to those whose title or properties match, without touching your saved filters.

• In-database search (the 🔍 in a view) is temporary and scoped to that database. Clear it and your filtered view snaps back.
• Quick Find (Ctrl/Cmd+P) searches your entire workspace — every page and database — when you don't know where something lives.

🎯 Project: Today / This Week / Completed

Time to turn your tasks (or reading) database from Module 3 into a set of focused screens. You'll add three views to the same database — no new databases, no duplicated rows — and feel the payoff firsthand. Everything here works on the Free plan.

🌅 Today
   Filter:  Due is Today  AND  Status is not Done
   Sort:    Priority (Descending)

📅 This Week
   Filter:  Due is within the next week  AND  Status is not Done
   Sort:    Due (Ascending)

✅ Completed
   Filter:  Status is Done
   Sort:    Due (Descending)

🗂️ Board (bonus)
   Layout:  Board
   Group by: Status

Best Practices for Views

✅ Do's

• Name views for their job. "🌅 Today" tells you what it's for; "Table 2" doesn't.
• Prefer relative date filters. "Is within the next week" never goes stale; a fixed date does.
• Filter first, then sort, then group. Get the right rows in before you fuss with order and clusters.

❌ Don'ts

• Don't duplicate the database to make "another list." Add a view instead — one source of truth.
• Don't over-nest sub-groups. One grouping level is usually plenty; more becomes noise.
• Don't panic at an empty view. Check the filter pills before assuming data is lost.

📓 Learning Journal

📝 Lesson Summary

🎉 What You've Accomplished

You turned a single database into "Today", "This Week", and "Completed" screens — and a kanban board on top — without duplicating a thing. This is the exact skill that makes Notion feel calm instead of overwhelming: you decide what deserves your attention, and the workspace shows you only that.

❓ Common Questions at This Stage

🔭 Looking Ahead

Next is the "aha" that turns a pile of separate databases into a connected system: Relations & Rollups. You'll link your Tasks to Projects, then have a Project automatically count its open tasks and show its percent complete — no manual tallying ever again.

✅ Before the Next Lesson

• Keep your Today / This Week / Completed views — you'll build on this database
• Make sure your tasks database has a clear Status property (we'll relate it next lesson)
• Write your Learning Journal entry for this lesson

📚 Additional Resources

• Notion Help — Views, filters & sorts
• Notion Help — Board view & grouping
• Notion Help Center