Hub › Lessons › Content planning, lesson 4
Build a Notion content calendar that shows what's due this week
A list of post ideas is easy to start and easy to ignore. What helps is a list that tells you, every time you open it, which posts are late, which are due in the next seven days and which still have no date. In this lesson you build that in Notion with four properties, one formula and two views. The formula was written by an AI assistant from the prompt on this page, and we tested it on 13 posts before publishing it here.
What you will be able to do: keep your planned posts in one Notion database that labels each one Late, Due this week or Add a date, with a "Needs attention" view for your weekly check and a calendar of publish dates. You will also have a prompt for asking AI to change the rules, and a short test to run before you trust the result.
What you need
- A Notion account and a page where you can add a database.
- Any AI chat assistant, such as Claude or ChatGPT, only if you want to change the formula. Notion's formula editor has its own Notion AI helper, but Notion's help page says that feature is available on Business and Enterprise plans, so this lesson does not depend on it.
- Your post ideas. If you did lesson 1 of this series, your month of topics is a good starting list.
Step 1: Create the database and its four properties
- Open a Notion page, type
/databaseand pick a database. Name it Content calendar. New databases are created as tables. - Rename the first column (the title) to Post.
- Click the + next to the last column to add the other properties. Type the names and the Stage options exactly as shown, because the formula looks for them.
The four properties. On a phone, scroll the table sideways.
| Property name | Type | What goes in it |
|---|---|---|
| Post | Title | A working title, e.g. "Customer FAQ: how long does setup take?" |
| Stage | Select | Four options: Idea, Drafting, Scheduled, Published |
| Channel | Select | Where it goes, e.g. LinkedIn, Newsletter, Blog |
| Publish date | Date | The day you plan to publish. Leave "Include time" off. |
We use a Select property for Stage, not Notion's Status property, so that you choose the stage names yourself and the formula can match them exactly.
Step 2: Add the "This week" formula
Click + to add a property, choose Formula, name it This week, select Edit formula, paste this and save.
ifs(prop("Stage") == "Published", "", empty(prop("Publish date")), "Add a date", dateStart(prop("Publish date")) < today(), "Late", dateBetween(dateStart(prop("Publish date")), today(), "days") <= 6, "Due this week", "")
Read it from left to right. ifs stops at the first rule that is true:
- A Published post shows nothing, whatever its date.
- A post with no publish date shows "Add a date".
- A post whose date is before today shows "Late".
- A post due today or in the next 6 days shows "Due this week".
- Anything further ahead shows nothing, so it stays out of the way.
dateStart makes the formula use the first day if you ever give a post a date range. today() ignores the time of day.
Step 3: Add two views
Needs attention (for your weekly check):
- Select + next to your database's view name, choose Table and name it Needs attention.
- Open the settings menu at the top of the database, select Filter, choose This week and set it to Is not empty.
- In the same menu, select Sort and sort by Publish date, oldest first, so late posts come to the top.
Calendar (to see gaps and clashes): select + again, choose Calendar and, if Notion asks, show it by Publish date.
Step 4: Check it with test posts
Before you rely on it, add a few made-up posts with dates around today and compare what Notion shows with the table below. These are the results Notion gave us. In our test, "today" was 26 October 2026, so "today + 6" means 1 November.
Test posts and the results Notion gave us (illustrative data). On a phone, scroll the table sideways.
| Stage | Publish date | This week showed | Why it matters |
|---|---|---|---|
| Drafting | today | Due this week | Today counts as this week |
| Scheduled | today + 3 | Due this week | Normal case |
| Scheduled | today + 6 | Due this week | Last day inside the window |
| Idea | today + 7 | (nothing) | First day outside the window |
| Drafting | yesterday | Late | Past and not published |
| Published | 10 days ago | (nothing) | Published posts are never late |
| Published | today + 2 | (nothing) | Published early: no label |
| Idea | (empty) | Add a date | No date yet |
| (no stage) | today + 1 | Due this week | A blank stage counts as not published |
| Drafting | range: today − 6 to today + 4 | Late | A range uses its start date |
The two rows on either side of the 7-day edge (today + 6 and today + 7) are the ones that matter most. If a formula counts the days the wrong way, or counts one day too many, these are the rows that show it.
Step 5: Change the rules with AI, then test again
You might want a different window, an extra label such as "Needs a draft", or your own stage names. An AI assistant can rewrite the formula, as long as you give it your exact property names and ask for test posts. This is the exact prompt we used to get the formula above. Change the property list and the rules to match yours, and keep the last part, which asks for edge cases and for the AI to say what it is unsure about.
I plan my content in a Notion database. These are its properties, with their types: - Post (title) - Stage (select: Idea, Drafting, Scheduled, Published) - Channel (select) - Publish date (date) Write a Notion formula for a new formula property called "This week". It should show: - "Late" when Stage is not Published and the publish date is before today - "Due this week" when Stage is not Published and the publish date is today or in the next 6 days - "Add a date" when Stage is not Published and there is no publish date - nothing in every other case (including every Published post) Rules: - Use today(), not now(), so the time of day does not matter. - Write the formula on one line so I can paste it into the formula editor. - After the formula, explain in one line per rule which part handles it. - Then give me 6 test posts I can add (publish date written relative to today, e.g. "today + 3 days") with the exact result each should show. Include the edge cases: today, today + 6, today + 7, yesterday, a Published post with a past date, and a post with no date. - If you are not sure how a Notion function behaves, say so instead of guessing.
Paste the formula, add the AI's test posts plus any of yours from the table above, and compare. If any result differs from what the AI predicted, tell it which row was wrong, what Notion showed and what you expected, and ask for a corrected formula. Then test again with the same rows.
Worked example: what the AI was unsure about, and what the test showed
On 27 October 2026 (Singapore time) we gave the prompt above to Claude. It returned the formula in Step 2, a one-line explanation per rule and six test posts. It also did what the last rule asked and listed what it had not checked. In its words:
- "I haven't run this in Notion. I'm confident
dateBetween(later, earlier, "days")returns a positive number when the first date is later, but I couldn't check it here. Tests 2 and 3 will confirm it, since they sit on the 6/7-day boundary." - "If your Publish date includes a time of day, I'm not certain whether
dateBetweenrounds partial days." - "I wrapped the date in
dateStart()so a date range would use its start date. I believe it's harmless for single dates, but I haven't verified that."
We tested each point in a Notion database. Its six test posts gave exactly the results it predicted, including today + 6 ("Due this week") and today + 7 (nothing), so the date direction was right. The date range used its start date. We also added three posts with a time of day: 3 pm (UTC) on today + 6 and 1 am (UTC) today both showed "Due this week", and 1 am (UTC) on today + 7 showed nothing. All 13 test posts matched.
This time the AI got it right first time. In lesson 6 of the money admin series, the first formula it wrote for us had past and future swapped. The difference is not that the AI got better. It is that the same short test caught the problem then and confirmed the formula now. Asking the AI to list what it is unsure about tells you which rows to test first.
Watch out for
- Names must match exactly. If you rename Stage, Publish date or the "Published" option, update the formula too, or every post will look unpublished.
- "Today" depends on the clock Notion uses. Our check ran through Notion's API at about 4 am Singapore time, and Notion counted today as 26 October (the UTC date). The Notion app may use your own time zone, so around midnight a post can switch from "Due this week" to "Late" a few hours earlier or later than you expect.
- Times of day. We tested three posts with a time and they behaved as expected, but only at a few times. If you plan with exact times, add your own edge rows near midnight, or keep "Include time" off.
- The filter. Use "Is not empty" on This week for the Needs attention view. That keeps Late, Due this week and Add a date posts together and hides everything else.
- Privacy. To get a formula written, the AI only needs property names and made-up test posts. You do not need to paste your real content plan.
Next step
Next: a voice guide for your drafts
Lesson 5 of this series uses three of your own posts to write a short voice guide, then uses it to edit new drafts so they still sound like you.
Go to lesson 5Fill the calendar
Each post in this database can start as a brief. Lesson 2 turns one topic into a one-page brief, and lesson 3 turns one finished post into short posts you can add as new rows.
See lesson 3Want it ready-made?
Our Notion Content Calendar template ($1.99, one-time) has this "This week" view built in, plus a pipeline board, an idea bank, post templates for four platforms, a hashtag bank and an engagement tracker. Everything in this lesson works without it.
See what's insideHow we checked this lesson
- On 27 Oct 2026 (about 3:50–4:20 am Singapore time) we created a test database in a real Notion workspace with the four properties and the formula on this page, added 13 illustrative posts, and read the formula results back through Notion's API by filtering on each result ("Due this week", "Late", "Add a date", empty). Every post gave the expected result. Notion's API counted today as 26 Oct.
- We created the database, formula and views through Notion's API rather than by clicking through the Notion app. They use the same formula language and view settings, but we did not use the formula editor itself on this run. A "Needs attention" view filtered on This week "is not empty" returned the 9 expected posts.
- The worked example used Claude Code 2.1.310 in print mode with the prompt above, unchanged. Quotes are as returned.
- Menu steps, the formula functions used (
ifs,empty,dateBetween,today), the property types, the Calendar view and the plan note for Notion AI in the formula editor were checked against Notion's help pages on 27 Oct 2026: Intro to formulas, Formula syntax & functions, Database properties and Views, filters & sorts.dateStartis not listed on the syntax page we checked; we confirmed it works by testing it. Notion changes its menus from time to time; the help pages are the authority. - AI output varies. Your assistant may write a different formula, or a wrong one. Test every formula before you rely on it.
- Last reviewed: 27 October 2026.