Notion Formulas for Beginners: The Complete Course

Notion formulas can turn a basic database into interactive, data-driven tools—starting with clickable links, then building real progress indicators, calendar-ready dates, cross-linked “latest activity” sorting, and finally an automated YouTube timestamp generator. The through-line is that formulas unlock capabilities Notion’s standard no-code controls can’t match, especially once you start converting data types, using conditionals, and iterating over related records.

Level one focuses on replacing a bulky URL column with a clean “button” icon. A formula property is created to output an emoji as text, then wrapped in Notion’s link function so the emoji becomes a clickable hyperlink. To make it look more like a button, the link output is further styled using the style function with code formatting. The lesson isn’t just the final formula—it’s how to think about function arguments and execution order: parentheses run first, so the hyperlink is created before styling is applied. The level also introduces method chaining (dot syntax) as a more compact way to apply functions like link and style to the same value.

Level two builds a habit-tracking “day score” progress ring. The key challenge is that habit checkboxes are boolean values (checked/unchecked), not numbers. The solution uses the two number function to convert each checkbox into 1 or 0, sums them to get the count completed, and divides by the total number of habits to compute a percentage. Parentheses are again crucial to enforce order of operations so division happens after the sum. Once the formula outputs a numeric value, Notion’s number formatting and progress ring UI become available, letting the database render the computed percentage directly.

Level three solves a birthday calendar problem where stored birth years are far in the past, so birthdays don’t appear when expected. The formula constructs “next birthday” dates by extracting month/day from the original date, combining them with the current year (using today, year, string concatenation, and parse date), and then using an if conditional to decide whether to keep the current year or advance to next year if the birthday has already passed. The result is a true date output that can be used in calendar views.

Level four refines the birthday logic using variables (let/lets) to avoid repeating long expressions and reduce error risk. It then escalates to a project tracker sorting problem: projects should sort by the most recent activity across connected tasks and notes, not just the project page’s own edited timestamp. The solution iterates through related task pages and note pages, maps each to their edited/updated timestamps, concatenates all dates into one list, sorts it, and returns the latest date (using list operations like reverse, first, and method chaining). That latest activity date becomes a sortable field for the projects view.

Level five culminates in a practical automation: generating YouTube timestamps from related “chapter marker” pages. The formula filters B-roll items down to those marked as chapter markers, sorts them chronologically by time code, maps each to a “timecode - title” string, and uses regular expressions to strip frame counts from timestamps. It then ensures the list includes a required “0000 introduction” entry using regex test logic and conditional concatenation. Finally, join turns the list into a newline-separated string ready to paste into a YouTube description. The overall impact is a repeatable pattern: convert data types, iterate through relations, apply conditionals, and use string/date tooling to make Notion behave like a lightweight application layer.