Grouping Database Views by Formulas

It is possible to group a database view by a formula property in Notion.

If you’d like to learn the basics of database grouping, check out this section in my database guide:

Notion Databases: The Ultimate Beginner’s Guide

Databases are Notion’s most powerful feature. This guide will teach you everything about them – including views, filters, sorts, grouping, and more!

thomasjfrank.com

When grouping a view by a formula property, the data type of the formula’s return value (i.e the output) determines your grouping options.

Notion formulas can output seven different data types:

When your formula outputs a string value, you’ll have the following grouping options:

• Exact Name
• Alphabetical (using the first letter of the output)

With number output, grouping is done by number ranges. The following options will be available:

• Group Range (e.g. 0 – 1,000,000)
• Group Every – a.k.a. the interval (e.g. 0 – 99,999, 100,000 – 199,999…)

When the formula returns a date, the following options will be available:

• Relative
• Day
• Week
• Month
• Year

Finally, when the formula returns a Boolean/Checkbox value, your view will be grouped by row that are checked vs. unchecked (no additional options are available).

Example Database

This example database contains four separate views; each one is grouped by a formula property that returns data of a different type – string, number, date, and Boolean/Checkbox.

View and Duplicate Database

Notion – The all-in-one workspace for your notes, tasks, wikis, and databases.

A new tool that blends your everyday work apps into one. It’s the all-in-one workspace for you and your team

thomasfrank.notion.site