Fix Notion Formula ‘Property Not Found’ Despite Visible in Schema

You see the error “Property Not Found” in a Notion formula field even though the property name appears correctly in the database schema. This happens because Notion formula syntax is case-sensitive and the property name must match exactly, including spaces and special characters. Additionally, formula fields cannot reference properties from a different database unless a relation and rollup are correctly configured. This article explains the exact causes of this error and provides step-by-step fixes to resolve it.

Why Notion Shows “Property Not Found” When the Property Exists in the Schema

Notion formulas use the prop() function to reference other properties in the same database. The function requires the exact property name as a string inside double quotes. If the name in the formula differs by even one character — a missing space, an extra hyphen, or wrong capitalization — Notion reports “Property Not Found.”

Another common cause is attempting to reference a property from a different database. A formula field can only access properties from the same database where the formula exists. To use data from another database, you must first create a relation column that links the two databases, then create a rollup field that pulls the desired value into the current database. Only after that can the formula reference the rollup field.

A third scenario is that the property name contains hidden characters or trailing spaces. These are invisible in the schema but break the formula. This often happens when you copy property names from an external source or from a table cell instead of from the column header.

Steps to Fix the “Property Not Found” Error in a Notion Formula

1. Open the database view and identify the formula field
   Navigate to the database that contains the formula field showing the error. Click the formula cell to open the formula editor.
2. Copy the exact property name from the schema
   Hover over the column header of the property you want to reference. Click the downward arrow icon that appears, then choose Copy link to property. This copies the exact name, including any spaces or special characters, to your clipboard.
3. Paste the property name into the formula
   Delete the existing property name inside the prop() function. Paste the copied name between the double quotes. The formula should look like: prop("Exact Property Name"). Do not add or remove any characters.
4. Check for hidden spaces in the property name
   If the error persists, edit the property name in the schema. Click the property header, choose Edit property, and delete any trailing spaces by placing the cursor after the last visible character and pressing Backspace or Delete. Then update the formula with the cleaned name.
5. Verify the formula uses the correct function syntax
   Ensure the formula uses prop() and not props() or property(). The function name must be lowercase and exactly prop. The property name must be inside double quotes, not single quotes or backticks.
6. If referencing a different database, create a relation and rollup
   Add a relation column to the current database that links to the target database. Then add a rollup column that selects the desired property from the related record. Finally, reference the rollup column — not the original property — in your formula.

If Notion Still Shows “Property Not Found” After the Main Fix

Formula references a property from a linked database directly

A formula cannot directly reference a property that belongs to a different database, even if that database is related through a relation column. The only way to bring data across databases is through a rollup field. To fix this, create a rollup field that pulls the value from the related database, then reference the rollup field in your formula.

Property name contains a slash or other special character

Notion formulas treat certain characters — such as forward slash, backslash, or colon — as syntax elements. If your property name includes one of these characters, the formula may misinterpret it. The safest fix is to rename the property to use only letters, numbers, spaces, hyphens, and underscores. Then update the formula with the new name.

The formula field is in a different database than the property

Double-check that the formula field and the target property are in the same database. Open the database view and look at the top bar to confirm you are in the correct database. If the formula is in a linked database view, it still belongs to the original database and can only reference properties from that original database.

Notion Formula Property Reference Methods Compared

Method	Syntax	Can reference other databases
Direct property name	prop("Name")	No
Rollup field reference	prop("Rollup Name")	Yes, through a relation

You can now fix the “Property Not Found” error by ensuring the property name is exact, using the correct prop() syntax, and setting up a relation and rollup when crossing databases. As a next step, review your database schema for any property names that contain special characters and rename them to avoid future errors. For complex formulas, consider using Notion’s built-in formula tester by typing a simple prop("PropertyName") first to confirm the reference works before adding logic.