AI Online Office All fixes
📓
Notion error

Fix “Syntax error in formula” in Notion

Notion's "Syntax error in formula" means the formula editor can't parse what you typed — a misspelled or wrongly-quoted property name, a missing comma between function arguments, unbalanced parentheses, a string that lost its double quotes, or the wrong operator. Read where the caret points, check that one spot against the six common causes, and fix it character by character rather than rewriting the whole formula.

Notion formulas fail in a handful of ways, and the error message gives you almost nothing — just "Syntax error" and a caret that points near the problem. The good news: the caret is honest. It is pointing at or just before the character Notion choked on. This page covers the six causes in rough order of how often they happen, with the exact checks for each, plus a simplify-and-rebuild method for the formulas that fight back.

What causes it — in the order they happen

A property name is misspelled or wrongly quoted

You'll know it's this if: The caret sits on or just after a prop("...") reference, or Notion flags the whole function it's inside.

The fix: Property names must match exactly, character for character, and be wrapped in double quotes inside prop(). Never type them by hand: type prop( and pick the property from the dropdown, or use @-mention in the editor. Invisible differences — an emoji, a trailing space, a capital letter — are the number-one cause of syntax errors in otherwise perfect formulas.

A missing comma between function arguments

You'll know it's this if: The caret points at the second argument of a function like if(), dateBetween() or contains().

The fix: Every argument in a Notion function must be separated by a comma. if(condition, "yes", "no") needs both commas — dropping the middle one is the classic. Count your arguments against the function's signature: if takes three, dateBetween takes three, contains takes two.

Unbalanced parentheses or quotes

You'll know it's this if: The caret points at the end of the formula, or Notion reports an error even though every function looks right.

The fix: Count opening and closing parentheses — nested ifs are the usual offender. Check that every string has a closing double quote, and that you used straight quotes (") not curly ones (“ ”) pasted from a doc or chat message. Curly quotes pasted from email or Slack break Notion formulas instantly.

Wrong operator for the comparison

You'll know it's this if: The caret points at = or a comparison that looks fine in any other tool.

The fix: Notion uses == for equality, not =. A single = is the assignment-style syntax that throws a syntax error. For "not equal" use !=, and for AND/OR use and, or, or && and ||. If you're copying a formula from a spreadsheet or another tool, operator differences are the first thing to check.

Mixing types that don't combine

You'll know it's this if: Notion underlines a value in red inside the editor — a text value where a number is expected, or a number where a date is expected.

The fix: Red underlines are type errors, and some surface as syntax errors. Text and numbers don't concatenate directly: convert first with format() to turn a number into text, or toNumber() the other way. Dates need date arithmetic (dateBetween, dateAdd) rather than subtraction with numbers.

Syntax from the old formula version (1.0)

You'll know it's this if: A copied formula from an old template, blog post or video fails immediately even though it looks well-formed.

The fix: Notion's current formulas (2.0) changed several functions and removed some 1.0-only syntax. Rebuild the copied formula from scratch in the editor, letting autocomplete fill in each function — if autocomplete doesn't offer the function as you type it, it no longer exists.

Fix it step by step

  1. 1

    Read where the caret points

    The caret in the error message marks the character Notion tripped on, or just before it. Start there — don't scan the whole formula. Nine times out of ten the problem is within a few characters of the caret.

  2. 2

    Check property references first

    Delete each typed property name and re-insert it via the prop( dropdown or @-mention. This fixes misspellings, trailing spaces, missing quotes and emoji differences in one pass — and it's the most common cause of the error.

  3. 3

    Balance the brackets and quotes

    Count every opening parenthesis against its closing pair, and every string against its closing quote. If you pasted the formula from anywhere — a doc, a chat, a blog post — replace the quotes with straight ones typed in Notion.

  4. 4

    Check commas and operators

    Verify each function has a comma between every pair of arguments, and that comparisons use == rather than =. Autocomplete is your friend here: start typing the function and match what you have against the signature Notion shows.

  5. 5

    Fix the red underlines

    Any value underlined in red is a type problem: wrap numbers in format() to join them with text, or use toNumber() to convert text. Dates need date functions, not arithmetic with plain numbers.

  6. 6

    If it still fights: simplify and rebuild

    Copy the formula into a note, delete the whole thing, and rebuild it piece by piece in the editor — condition first, then one branch, then the other. Test after each piece. The error reappears the moment you add the broken part, so you find it in one or two steps instead of staring at the whole thing.

Stop it coming back

  • Always insert property references with the dropdown or @-mention — never type them by hand.
  • Type formulas in the Notion editor; never paste from documents, emails or chat without retyping the quotes.
  • Build complex formulas incrementally and check for errors after each piece instead of writing the whole thing at once.
  • When copying formulas from templates or tutorials, rebuild rather than paste — old 1.0 syntax and curly quotes both break on arrival.

Still stuck on the exact screen?

Paste a screenshot of the error into AI Online Office and it tells you what to click next — on your screen, in seconds.

Fix it with AI Online Office

Notion error FAQ

Why does Notion say syntax error when the formula looks right?

The usual hidden causes are a property name that doesn't exactly match (an emoji, trailing space or capital letter), curly quotes pasted from another app, a single = instead of ==, or a missing comma between arguments. Re-inserting each property reference from the dropdown usually finds it.

What does the caret in the error mean?

It marks where Notion's parser stopped — the broken character, or the one just before it. Start your search there rather than reading the whole formula.

Does Notion use = or == in formulas?

Notion uses == to test equality. A single = throws a syntax error. For not-equal use !=, and combine conditions with and / or (or && / ||).

Why can't I add a number to text in a Notion formula?

Types must match. Convert the number to text with format() first, then combine — or convert text to a number with toNumber(). Values that can't combine show as red underlines in the editor.

How do I fix a long Notion formula that's too messy to debug?

Simplify and rebuild: save a copy of the formula in a note, delete it, and rebuild piece by piece in the editor, testing after each piece. The error returns exactly when you re-add the broken part.

Other errors we fix

New to the tool rather than the error? Start with the plain-English guides, or read what an AI Online Office is.