Counting Database Entries with Notion Formulas 2.0 Filter() and Length()

The speaker introduces the concept of counting and filtering database entries using Notion Formulas 2.0, highlighting the improvements over the previous version, Notion Formulas 1.0. In the previous version, users had to employ workarounds to count the number of database entries related to another entry. The speaker explains the usage of the Map function to count related tasks and demonstrates how the do notation with dot length provides the numerical representation of tasks associated with a project. They emphasize the efficiency of the length formula in simplifying the process for users.

Furthermore, the segment explores utilizing the Filter formula to count tasks based on specific criteria. The speaker illustrates using the Filter formula in conjunction with properties like task status and a checkbox to efficiently filter and count entries that meet the specified criteria. They demonstrate how the length formula complements the Filter formula, enabling users to obtain valuable insights by representing the count of entries meeting the given criteria.

The discussion then progresses to employing the checkbox property to filter out tasks related to a project and using a new formula to filter entries based on numerical criteria. Users can specify criteria, such as checking for empty checkboxes or filtering entries with numbers greater than a specified value. The speaker emphasizes the intuitive nature of the formulas and the enhanced capability to obtain meaningful insights through counting and filtering based on varied criteria, making the process immensely helpful and efficient for users.

  • Maximizing Productivity in Notion with Notifications, Reminders, and Automations

  • Sort By Earliest and Latest Date in Notion Formulas 2.0 Sort(), First() and Last()