Why Notion Formula Cannot Reference Property With Special Character

When you write a Notion formula that tries to reference a property whose name includes a special character such as a hyphen, slash, apostrophe, or parenthesis, the formula often returns an error or fails to save. This happens because Notion’s formula syntax treats certain characters as operators or delimiters, breaking the reference. This article explains the exact characters that cause the problem and shows you how to write a valid property reference that works every time.

Why Notion Formula Fails With Special Characters in Property Names

Notion formulas use a syntax similar to JavaScript or Excel where certain characters have reserved meanings. When you write prop("Task-Status"), the hyphen is interpreted as a minus operator, not as part of the property name. The same problem occurs with slashes (interpreted as division), apostrophes (string delimiter conflict), parentheses (grouping operator), and spaces (argument separator).

The formula engine parses the text inside the quotes but also checks for operators outside the quotes. A hyphen directly inside the parentheses of prop() is ambiguous. Notion sees the hyphen and tries to evaluate it as a subtraction between two property references, which causes a parse error. The error message usually says “Invalid formula” or highlights the problematic character in red.

Characters That Break Property References

The following characters cause parsing errors when used in a property name inside a prop() call without escaping:

• Hyphen or minus sign (-)
• Forward slash (/)
• Backward slash (\)
• Apostrophe or single quote (‘)
• Parentheses ( )
• Brackets [ ]
• Braces { }
• Plus sign (+)
• Asterisk ()
• Percent sign (%)
• At sign (@)
• Exclamation mark (!)
• Question mark (?)
• Colon (:)
• Semicolon (;)
• Double quote (“)

Spaces inside the property name do not break the reference if the name is quoted properly. But the formula engine may still fail if the space appears adjacent to a special character.

Steps to Reference a Property With a Special Character

You have two reliable methods to reference a property whose name includes a special character. Use the backtick escape method when you want to keep the original property name. Use the rename method when you prefer cleaner syntax.

Method 1: Use Backticks to Escape the Property Name

1. Identify the exact property name
   Open the database in Notion and look at the column header. For example, the property might be named “Task-Status” or “Project/Phase”.
2. Write the formula with backticks
   Instead of prop("Task-Status"), write prop("Task`-`Status"). Place a backtick before and after each special character. For a property named “Project/Phase”, write prop("Project`/`Phase").
3. Test the formula
   Click Save in the formula editor. If the formula still shows an error, add backticks around the entire property name: prop("`Task-Status`"). This treats the whole name as a literal string.
4. Use backticks for multiple special characters
   For a property like “Cost+Tax% (Final)”, write prop("Cost`+`Tax`%` `(`Final`)`"). Each special character or space adjacent to a special character gets its own backtick pair.

Method 2: Rename the Property to Remove Special Characters

1. Click the property header
   In the database view, click the column header of the property you want to rename.
2. Select Rename
   From the dropdown menu, choose Rename. The property name becomes editable.
3. Replace special characters with underscores or camelCase
   Change “Task-Status” to “Task_Status” or “taskStatus”. Change “Project/Phase” to “Project_Phase” or “projectPhase”. Avoid using any character from the list above.
4. Update all formulas that reference the old name
   Every formula that used prop("Task-Status") must be edited to use the new name. Notion does not automatically update formula references when you rename a property.

If Notion Formula Still Fails After Using Backticks

Formula Editor Shows Red Underline After Backtick Escape

The most common mistake is placing backticks in the wrong position. The backtick must immediately precede and follow the special character without spaces. For example, prop("Task - Status") has a space before and after the hyphen. You must write prop("Task` `-` `Status") to escape both spaces and the hyphen. If the error persists, wrap the entire property name in backticks: prop("`Task - Status`").

Formula Saves but Returns Wrong Value

If the formula saves without an error but returns an unexpected result, the backtick escape may have created a different property reference. For instance, prop("Task`-`Status") might reference a property literally named “Task`-`Status” instead of “Task-Status”. Check the actual property name by opening the property settings. If the literal name includes backticks, rename the property to avoid confusion.

Backtick Escape Does Not Work for All Characters

The backtick escape method works for most special characters, but Notion has not documented every edge case. Characters like the double quote (“) may still cause issues because they conflict with the string delimiter. If you cannot escape a character successfully, rename the property to remove that character entirely.

Notion Formula Reference Methods Compared

Item	Standard prop() Syntax	Backtick Escape	Renamed Property
Example input	prop(“Task-Status”)	prop(“Task`-`Status”)	prop(“Task_Status”)
Supports hyphens	No	Yes	Yes (after rename)
Supports slashes	No	Yes	Yes (after rename)
Supports spaces	Yes (with quotes)	Yes	Yes (no spaces)
Requires formula edits after property rename	Yes	Yes	No (if you rename first)
Readability	High	Low (backticks clutter the formula)	High

The backtick escape method is the only way to keep the original property name with special characters. The rename method gives you cleaner formulas and fewer syntax issues. Choose the rename method if you control the database schema and can change the property name without breaking other formulas.