Easy Spaced Repetition Formula In Notion

Spaced repetition in Notion can be automated with a single “push the next review date” formula that moves review sessions forward whenever a user marks progress. The core setup starts with a database that tracks an original review date and then uses checkboxes (or select fields) to trigger date changes. When “session 1” is completed, the formula adds a fixed number of days to the “next review” date; additional sessions can stack those intervals so later sessions push the review further out.

The walkthrough begins with a database containing subjects and a date property representing the first time a note is reviewed. A checkbox called “session 1” is added, and a formula property (“next review”) uses Notion’s dateAdd function: if session 1 is checked, it adds three days to the original date; if not, it leaves the date unchanged. To extend the system, “session 2” and “session 3” are added as additional checkboxes. The formula is adjusted so each checked session adds another three-day interval—effectively turning session 1 into +3 days, session 2 into +6 days, and session 3 into +9 days. The ordering of conditions matters: session-related conditions are placed so earlier checks respond first and later checks respond last, ensuring the correct total offset is applied.

A second approach replaces checkboxes with select properties to make the scheduling depend on performance rather than just completion. For each session (session 1, session 2, session 3), a select field offers options like “poor,” “good,” and “great,” each mapped to a specific number of days to push the review forward (for example, 1 day for poor, 4 days for good, and 7 days for great). Instead of hardcoding values, the formula pulls the numeric day offset from the select option and sums the offsets across sessions. That sum then feeds directly into dateAdd, so the next review date moves relative to the original date based on how well the material was understood.

Once scheduling logic is in place, the system becomes usable through views and filters. Sorting by the closest “next review” date helps prioritize what’s due soonest. A “today” view can be created with a filter that selects rows where “next review” equals today, turning the database into a daily queue. For calendar-style visualization, a calendar view grouped by the original date can be used; it’s effectively read-only for creating new items, but it still allows adding entries by date through the calendar interface.

Overall, the method turns spaced repetition into a practical workflow: mark session outcomes, let formulas calculate the next review date automatically, and use views (sorted lists, “today” filters, and calendar grouping) to manage what to study next.