🧮 Lesson 4.1: Formulas 2.0: Thinking in Formulas

What a Formula Really Is

A formula in Notion is a property type, like text or date. But instead of you typing a value, you write a little instruction and Notion computes the value for every row — freshly, every time something changes. That's the whole idea:

A formula is an expression that looks at the current row and returns exactly one value.

"Expression" just means "something that works out to a value." 2 + 2 is an expression (it returns 4). "Hello " + "world" is an expression (it returns "Hello world"). And prop("Due") < now() is an expression that returns true or false depending on whether the row's Due date is in the past. Everything you write in a Notion formula is one big expression that boils down to a single answer.

Data Types: The Kinds of Values

Every value in a formula is one of a few types. Knowing the type matters because functions expect certain types — you can't add two dates the way you add two numbers. The everyday types:

The formula editor tells you the type of your result at the bottom as you type — a quiet, friendly way to catch mistakes. If you expected a number and it says "Text," something upstream is the wrong type.

Referring to Properties with prop()

A formula becomes useful the moment it can look at the row's other properties. You do that with prop() — you pass it the property's name, exactly as spelled, in quotes:

prop("Due")          → this row's Due date
prop("Done")         → this row's Done checkbox (true/false)
prop("Task")         → this row's Task title (text)
prop("Priority")     → this row's Priority value

Think of prop("Name") as "the value in this row's Name column." Because a formula runs per row, prop("Due") means a different date on every row — always the current row's.

The Dot / Function Style

Formulas 2.0 lets you apply a function in two equivalent ways. Meet them both — you'll see each in tutorials, and they do exactly the same thing:

// classic style: function(thing)
length(prop("Task"))

// dot style: thing.function()
prop("Task").length()

Read the dot style left to right, like a little pipeline: "take the Task, then get its length." It shines when you want to do several steps in a row, because you can chain them:

prop("Task").lower().contains("email")
// take Task → make it lowercase → does it contain "email"? → true/false

Both styles produce the same value; use whichever reads more clearly to you. Many people prefer the dot style for chains and the classic style for one-off calls. There's no wrong choice.

Operators are the tiny built-in functions you already know from math and logic:

Making Decisions with if

The single most useful formula tool is if. It picks between two answers based on a condition. Read it as: if (this is true) then (give this) else (give that).

if(prop("Done"), "✅ Complete", "⏳ In progress")
//  condition        if true         if false

So a row whose Done checkbox is ticked shows "✅ Complete"; every other row shows "⏳ In progress". Here's the everyday hero of this lesson — a friendly overdue flag:

if(prop("Done"),
   "Done",
   if(prop("Due") < now(), "⚠️ Overdue", "🟢 On track"))

That reads: if it's done, say "Done"; otherwise, if the due date is in the past say "⚠️ Overdue", else "🟢 On track". Notice we nested one if inside another to handle three outcomes.

When you have many outcomes, nesting ifs gets hard to read. ifs is the cleaner tool — a list of condition/answer pairs, with a final fallback:

ifs(
   prop("Score") >= 90, "A",
   prop("Score") >= 80, "B",
   prop("Score") >= 70, "C",
   "Keep going"        // the fallback if nothing above matched
)

A Few Functions Worth Knowing

You'll build 90% of your formulas from a small handful of functions. Here are the ones to meet today — just enough to be dangerous, no memorizing required:

A friendly "days until due" using two of them together:

if(empty(prop("Due")),
   "No due date",
   format(dateBetween(prop("Due"), now(), "days")) + " days left")

If there's no Due date, say so; otherwise compute the day gap and glue it onto the words " days left" (using format() so the number can join the text).

🎯 Project: Your First Formula

Let's add one genuinely useful formula to your Tasks database. Pick whichever appeals — an Overdue? flag or a friendly status label — and build it. The formula property is available on the Free plan; no add-on required.

// Option A — friendly status label
if(prop("Done"),
   "Done",
   if(empty(prop("Due")),
      "No date",
      if(prop("Due") < now(), "⚠️ Overdue", "🟢 On track")))

// Option B — simple Overdue? (shows a warning or nothing)
if(prop("Done"), "",
   if(prop("Due") < now(), "⚠️ Overdue", ""))

Best Practices for Formulas

✅ Do's

• Build in small steps. Get one piece working, check the result, then add the next.
• Use autocomplete for prop(). It spells names correctly and survives renames.
• Read the result type at the bottom of the editor to catch type mismatches early.
• Copy and adapt. Starting from a working formula beats writing from a blank editor.

❌ Don'ts

• Don't mix types. Wrap numbers with format() before joining them to text.
• Don't cram everything into one giant nested if — reach for ifs when there are many cases.
• Don't try to memorize functions. Understand the shape; look the rest up.

📓 Learning Journal

📝 Lesson Summary

🎉 What You've Accomplished

You wrote a formula that reads your data and returns a helpful, always-current label — and you understood why it works, not just where to paste it. That mental model (expression → one value) is the key that unlocks every formula you'll ever meet.

❓ Common Questions at This Stage

🔭 Looking Ahead

Next up is the fun part: Practical Formula Patterns — a cookbook of copy-paste recipes for progress bars, days-until-due, auto status labels, conditional 🔴🟡🟢 indicators, and more. Bring the formula you built today; you'll add a couple of these recipes to it.

✅ Before the Next Lesson

• Keep your new formula property — we'll build recipes onto the same database
• If you did the Projects + Tasks relation, make sure your "% complete" rollup still works (we'll turn it into a progress bar)
• Write your Learning Journal entry for this lesson

📚 Additional Resources

• Notion Help — Formulas
• Notion Help — Formulas 2.0 overview
• Notion Help Center