MUST-KNOW Notion Formulas for Beginners | Date, Text, If, Calculations, and More!

Notion formulas don’t have to be intimidating: beginners can start by using a handful of built-in functions to format text, compute date differences, build progress-style metrics, and generate conditional messages—then scale up to counting related records. The payoff is practical automation inside a database, from “how many days left?” to “good job” when a checkbox is ticked.

The first formula technique focuses on styling. By adding a Formula property and using the `style` function, users can apply formatting and colors directly to another property’s value. Valid formatting styles include bold, underline, italics, code, and strike-through, while colors range across gray through red. The transcript shows how to wrap a property (like `name`) inside `style(...)`, then supply a style keyword (e.g., bold) and optionally a color and background (using an underscore prefix for background). The same approach can format other property types too—such as turning a multi-select tag into a consistently styled label.

Next comes date math, built around date properties and functions like `date between`, `date add`, `date range`, and `format date`. `date between` calculates the number of days separating two dates, with the larger (more current) date placed first and the older date second. A simple example demonstrates returning “5” when dates are the 12th and 17th, and the formula can be extended to output human-readable text like “5 days.” For forward-looking tracking, `date add` supports adding time intervals such as one week to a date—useful for subscription renewals or recurring schedules. `date range` constructs a combined range from a start and end date, while `format date now` with `HHmm a` outputs the current time in a readable format including AM/PM.

For numeric progress, the transcript uses multiple number properties—pages read and total pages—to compute a percentage via division. That percentage can then be displayed as a progress bar or ring by switching the formula’s number format to percent. The same calculation pattern supports more complex equations, including scaling values (such as multiplying by 100,000) when needed.

Conditional logic arrives through `if` statements tied to Boolean values like checkboxes. When a completion checkbox is true, the formula returns a message such as “good job”; when false, it returns blank. Finally, formulas can summarize relationships. After creating a relation between two databases (e.g., tasks and subtasks), the formula uses `length` on the related set to count how many subtasks belong to each task, producing a simple number (like “2”) without listing every related record.

Taken together, these beginner-friendly patterns—`style`, date functions, percentage calculations, `if` logic, and `length` over relations—form a practical foundation for building more complex Notion automations.