Get AI summaries of any video or article — Sign up free
Notion for Productivity: My Favorite Weekly Spread (Free Template) thumbnail

Notion for Productivity: My Favorite Weekly Spread (Free Template)

Red Gregory·
5 min read

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

TL;DR

Use a tasks database with a Date property (with optional time) and a Status property to power the weekly Timeline layout.

Briefing

A clean weekly task spread in Notion can be built from a single tasks database by combining Timeline view, side peak task previews, and two lightweight formula fields that label tasks by week and extract start times. The payoff is a dashboard-like weekly layout that stays tidy—showing only Monday–Sunday tasks for “this week” or “next week,” while automatically displaying either a specific time (e.g., 12 P.M.) or “all day” when no time is set.

The setup starts with a tasks database that includes at least a Date property and a Status property. The Date field can include time for some tasks and be time-less for others; Notion’s date settings also allow toggling end dates and time display. For the weekly spread to remain readable, the database is paired with a Pipeline (board view) and a filter that hides clutter: completed tasks older than a week are removed, inbox tasks scheduled too far in the future are excluded, and only active items (like “working”) remain.

Next comes the weekly view itself. A new database view is created from the same tasks database, set to Timeline and configured to display Week mode (with the red “today” line acting as the anchor). Sorting by date ascending improves scanability, and the card/table property display is tuned so the task name appears only where intended. To isolate tasks to the current week, a formula property named “week” is added. It uses Notion’s date formatting to compute the week number (capital “W” for Monday–Sunday weeks) and returns either the string “this week” or a blank. A view filter then keeps only rows where the “week” formula contains “this week.”

A second formula property, “start time,” turns the Date field into a display-friendly scheduling cue. It formats the time portion (using “LT”) when a task has a time, but when the Date resolves to 12 a.m. (a common marker for “no time provided”), it outputs “all day.” This “start time” field is then shown in the weekly Timeline cards alongside Status, giving each task a quick scheduling glance.

For aesthetics and dashboard use, the weekly view is placed on an empty page via a linked database view. Linked views preserve the original filters and sorts while allowing the layout to live inside a callout-based block. The result is a compact weekly spread with cards that open in side peak—making it possible to edit task properties without leaving the weekly context.

Finally, “next week” is created by duplicating the “this week” view and adjusting the “week” formula. A second formula branch converts the current week number into a numeric comparison (using Notion’s two number conversion) so tasks whose week number equals “this week + 1” are labeled “next week.” The duplicated view is filtered to show only “next week,” enabling planning by adding tasks directly into the correct week from the dashboard-style layout.

Cornell Notes

A Notion weekly spread can be built from a tasks database by using Timeline view in Week mode, side peak task previews, and two formula fields. First, a “week” formula labels tasks as “this week” or “next week” by comparing the week number derived from the Date property (capital “W” for Monday–Sunday). A view filter then shows only tasks whose “week” formula matches the target label. Second, a “start time” formula formats the time from the Date property when a time exists, but outputs “all day” when the Date is effectively 12 a.m. For a dashboard feel, the weekly view is embedded on an empty page using a linked database view and callout styling.

What minimum database fields are needed to generate the weekly spread, and why do they matter?

A tasks database needs a Date property and a Status property. The Date property drives both the Timeline week layout and the formulas that label tasks by week and extract start time. The Status property is displayed on the weekly cards so tasks can be scanned by workflow stage (e.g., inbox, working, complete). Without Date, the Timeline can’t anchor tasks to Monday–Sunday, and without Status the cards lose the workflow context the spread is meant to provide.

How does the “week” formula isolate tasks to Monday–Sunday for “this week” (and later “next week”)?

The “week” formula uses Notion’s format date function to compute a week number from the Date property. Using capital “W” returns the week number in the year for weeks Monday through Sunday. The formula returns the string “this week” when the formatted week number matches the current week number; otherwise it returns a blank. A view filter then keeps only rows where the “week” property contains “this week,” which removes tasks outside the target range.

What logic determines whether a task shows a specific time or “all day”?

The “start time” formula formats the time portion of the Date property using LT. It wraps that in an if condition that checks whether the Date effectively equals 12 a.m. When the Date has no time component, it resolves to 12 a.m., and the formula returns the string “all day.” When a time exists, the formula returns the formatted time (e.g., “9am” or “12 P.M.”).

Why use a linked database view on an empty page instead of building everything directly there?

A linked database view lets the weekly layout live inside a dashboard-style page while keeping the original database as the source of truth. Filters and sorts from the original “this week” view can be copied into the linked view, so the weekly spread stays consistent. Edits made through the linked view still affect the original tasks, but the layout can be customized independently—like embedding the cards inside a callout block.

How is “next week” created without rebuilding the whole weekly system?

“Next week” is made by duplicating the “this week” view and changing the “week” formula logic. Instead of only checking equality to the current week number, the formula converts the formatted week number into a numeric value (via a two number conversion) and compares it to “this week + 1.” The duplicated view then filters for rows where the “week” property contains “next week.”

What role does side peak play in the weekly spread workflow?

Side peak provides a compact task detail/editor panel when a card is clicked. That means the weekly layout remains visible while editing properties like Date, Status, or other fields. It’s especially useful for quickly adjusting tasks on Friday or updating a task’s time without disrupting the weekly context.

Review Questions

  1. How would you modify the “week” formula if you wanted weeks to run Sunday–Saturday instead of Monday–Sunday?
  2. What specific condition in the “start time” formula triggers the “all day” output, and what does it return when that condition is false?
  3. If tasks are missing from the weekly view, which two places would you check first: the view filter logic or the Date property’s time settings?

Key Points

  1. 1

    Use a tasks database with a Date property (with optional time) and a Status property to power the weekly Timeline layout.

  2. 2

    Create a Timeline view in Week mode and sort by Date ascending for a cleaner weekly scan.

  3. 3

    Add a “week” formula that labels tasks as “this week” or “next week” using formatted week numbers (capital “W” for Monday–Sunday).

  4. 4

    Filter the weekly view by the “week” formula so only Monday–Sunday tasks appear.

  5. 5

    Add a “start time” formula that shows formatted time when a time exists, but outputs “all day” when the Date resolves to 12 a.m.

  6. 6

    Embed the weekly spread on an empty page using a linked database view and style it with callouts for a dashboard-like look.

  7. 7

    Duplicate the “this week” view to create “next week” by adjusting the “week” formula to compare against “this week + 1.”

Highlights

A weekly spread becomes practical when tasks are labeled by week using a formula and then filtered by that label—no manual date ranges required.
The “start time” formula uses a 12 a.m. check to automatically switch between showing a specific time and the text “all day.”
Linked database views let the weekly layout sit inside a dashboard-style page while edits still update the original tasks.
Side peak keeps the weekly context visible while editing task details, making quick scheduling changes easier.