Get AI summaries of any video or article — Sign up free
EASY writing tracker in Notion (beginner tutorial + free template) thumbnail

EASY writing tracker in Notion (beginner tutorial + free template)

5 min read

Based on The Organized Notebook's video on YouTube. If you like this content, support the original creators by watching, liking and subscribing to their content.

TL;DR

Create a single Notion table database with Date and a Number property for the daily metric (Word Count in the template).

Briefing

A beginner-friendly Notion setup can turn daily writing into a measurable habit by combining a single database, a goal-checking formula, and automatic rollups for totals. The core build is a “word count tracker” database with three key fields: a Date, a Number for Word Count, and a Formula that marks each day as “met” or “not met” based on whether the entry reaches a chosen daily target (for example, 1,000 words). To make results instantly readable, the formula outputs a checkmark emoji when the goal is hit and an X emoji when it isn’t.

The workflow starts on a blank Notion page, where the template is titled and styled with a cover image from Unsplash and an icon from Notion’s icon set. From there, a single table database is created (with the database title hidden for a cleaner look). Unneeded properties like tags are removed, and a Date property is added alongside a Word Count number property. The goal logic then becomes the centerpiece: a Formula property named “Writing goal” (or similar) uses an IF condition that compares the Word Count against the daily threshold using a “greater or equal” check. If the condition is true, the formula returns the “met” value; if false, it returns “not met,” with the checkmark and X inserted as emojis for quick visual scanning.

To support longer-term progress, the tracker adds a Notes text property for freeform comments about each writing session. It also uses a rollup-style calculation in the table view: the “calculate” option sums the Word Count across entries, producing a running total for the selected view. The main view is renamed to “All,” then sorted by Date—typically descending so the newest entries appear first.

From there, the template multiplies insights through additional database views rather than extra databases. A “Monthly” view duplicates the “All” view and groups entries by month using the Date property, allowing totals like “September” and “October” to appear as grouped sums. An “Yearly” (labeled “early” in the transcript) view duplicates again and groups by year, with options to hide empty groups and control whether newest groups appear first. These grouped views make it easy to see monthly and yearly writing totals at a glance.

Finally, the transcript highlights a practical way to track word counts directly inside Notion pages: Notion’s page menu includes a “word count” section with last edited details, and database entries also show word count values when pages are opened and edited. The template’s flexibility is emphasized throughout—any numeric daily goal can use the same structure, whether tracking pages read, minutes run, or other measurable targets—so long as the formula’s threshold is updated to match the user’s goal.

Cornell Notes

The template builds a Notion word count tracker using one database with Date, Word Count (number), Notes (text), and a Formula that checks whether each day meets a chosen target. The formula uses an IF condition with a “greater or equal” comparison against the daily goal and outputs a checkmark emoji for “met” and an X emoji for “not met.” A table view can sum word counts for totals, while duplicated views group entries by month and by year to show monthly and yearly totals. The same structure works for any daily numeric habit—pages read, minutes run, or similar—by changing the goal threshold in the formula.

How does the tracker decide whether a day’s writing goal is met?

It relies on a Formula property using an IF statement. The condition checks whether the Word Count value is “greater or equal” to the daily target (e.g., 1,000). If the condition is true, the formula returns the “met” output; if false, it returns “not met.” The transcript also adds emojis to make the status instantly visible: a checkmark for met and an X for not met.

What are the minimum properties needed in the database?

The database uses a Date property, a Word Count number property, and a Formula property for goal status. It also optionally includes a Notes text property for comments about that writing session. Tags are removed unless the user wants them, and the database layout is adjusted to hide the database title for a cleaner page.

How are monthly and yearly totals generated without creating new databases?

The template duplicates the main “All” view and changes only the view settings. For Monthly, it groups by the Date property at the month level, producing grouped totals like September and October. For Yearly, it groups by the Date property at the year level. Both views can hide empty groups and sort groups so the newest appear first.

How does the tracker compute totals across entries in a view?

In the table view, it uses Notion’s “calculate” option to sum the Word Count column for the current view. As entries are added (e.g., 1,200 words on one day and 2,000 on another), the sum updates (the transcript gives an example totaling 3,220 across those days).

What’s the flexible part of the template beyond word count?

The formula’s threshold is the key customization point. If the goal changes from 1,000 words per day to 300 pages or 3,000 words per day, the user updates the number in the formula accordingly. The same database structure can track any daily numeric metric as long as it fits the Date + Number + goal-check formula pattern.

How can Notion’s built-in word count help alongside the tracker?

Notion pages show a “word count” section (including last edited by and date/time). When working inside database entries, opening a page and typing content also reveals word count values in the page’s menu area, providing an additional way to verify word counts while using the tracker’s database fields.

Review Questions

  1. What exact comparison does the formula use to determine “met” versus “not met,” and where is the daily goal value entered?
  2. How do duplicated views differ from adding new databases in this template’s monthly and yearly tracking approach?
  3. If someone wants to track minutes run per day instead of words, which properties and formula parts must be changed?

Key Points

  1. 1

    Create a single Notion table database with Date and a Number property for the daily metric (Word Count in the template).

  2. 2

    Use a Formula property with an IF condition and a “greater or equal” comparison to check whether the daily goal is reached.

  3. 3

    Add checkmark and X emojis in the formula output to make goal status readable at a glance.

  4. 4

    Use a Notes text property to capture context for each entry without affecting calculations.

  5. 5

    Sum the Number property in the table view using the calculate option to get totals for the current view.

  6. 6

    Duplicate the main view and group by month and by year to produce monthly and yearly totals, with options to hide empty groups.

  7. 7

    Update the formula’s goal threshold whenever the daily target changes, since the same structure works for other numeric habits too.

Highlights

The goal-status formula is driven by a simple IF check: Word Count must be “greater or equal” to the daily target to show “met.”
Monthly and yearly reporting comes from duplicated views that group by Date at different granularities—no extra databases required.
Emoji outputs (checkmark for met, X for not met) turn a formula result into a quick visual dashboard.
Notion’s built-in page word count can complement the database tracker when editing entries.

Topics