🧠 AI Learning Hub

Hub › Lessons › Content planning, lesson 4

Lesson 4 · AI for your content planningAbout 20 minutes

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

Step 1: Create the database and its four properties

  1. Open a Notion page, type /database and pick a database. Name it Content calendar. New databases are created as tables.
  2. Rename the first column (the title) to Post.
  3. 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 nameTypeWhat goes in it
PostTitleA working title, e.g. "Customer FAQ: how long does setup take?"
StageSelectFour options: Idea, Drafting, Scheduled, Published
ChannelSelectWhere it goes, e.g. LinkedIn, Newsletter, Blog
Publish dateDateThe 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.

Formula: This week (tested)
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:

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):

  1. Select + next to your database's view name, choose Table and name it Needs attention.
  2. Open the settings menu at the top of the database, select Filter, choose This week and set it to Is not empty.
  3. 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.

StagePublish dateThis week showedWhy it matters
DraftingtodayDue this weekToday counts as this week
Scheduledtoday + 3Due this weekNormal case
Scheduledtoday + 6Due this weekLast day inside the window
Ideatoday + 7(nothing)First day outside the window
DraftingyesterdayLatePast and not published
Published10 days ago(nothing)Published posts are never late
Publishedtoday + 2(nothing)Published early: no label
Idea(empty)Add a dateNo date yet
(no stage)today + 1Due this weekA blank stage counts as not published
Draftingrange: today − 6 to today + 4LateA 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.

Copyable prompt: write a Notion formula for a content calendar
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:

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

Next step

How we checked this lesson