Notion Formulas Update Overview

Introduction

• Notion formulas have become simpler, easier, and more fun to use.
• This video is part one of a three-part series on Notion formulas.
• Topics covered include creating a habit tracker, project overview, and financial summary.

Major Changes in Notion Formulas

Support for New Data Types

• Now supports: dates, people, lists, and page data types.
• Previously only supported: text, numbers, and checkboxes.

Formula Reference Changes

• New property references appear as simple property names with a gray background.
• When copied to a code block, it appears with the old prop function format.

Enhanced Formula Editor Features

• Press Shift + Enter for multiple lines.
• Use step for line indentations.
• Use / and ** ** for comments, similar to coding.

Dot Notation

• Use dot notation for functions instead of traditional function syntax.
• Old syntax still works but new dot notation is cleaner.

Formula Update Behavior

• Formulas do not update until Done is clicked.
• A revert button is available to undo recent changes.
• Error parts are underlined in red for easier identification.

Wrapping Long Formulas

• To wrap long formulas, enable "wrap all columns" in the database menu under layout.

Examples of New Formulas

Habit Tracker Formula

• Transition from unaryPlus to toNumber function.
• Clean formula structure using dot notation.
• Use round function to remove decimals.

Project Overview Formula

• Create a formula to track completed and uncompleted tasks.
• map function used for accessing related database information without rollups.
• filter function filters completed tasks.
• Use length function to count checked boxes.
• lets function allows for naming variables for cleaner formulas.
• Includes conditional statements for singular/plural task labels.
• style function for text formatting (bold, color).

Financial Summary Formula

• Condense 12 properties into a single formula.
• Use sum function for total income and expenses.
• Profit calculated by subtracting total expenses from income.
• Formatting text with style and replace function for currency formatting.
• Ensure column wrapping to avoid text misalignment.

Conclusion

• Viewers encouraged to check out the Life OS dashboard and subsequent parts of the series for further learning.