When you write a formula in a Notion database, you may see the error “Cannot find property” next to a property name you know exists. This error stops the formula from calculating and often appears after renaming a property or switching from a different formula editor. The root cause is that the formula still points to the old internal name of the property, not the current display name. This article explains why this mismatch happens and provides exact steps to fix the reference so your formula works again.
Key Takeaways: Fixing a “Cannot Find Property” Error in Notion Formulas
- Click the property name in the formula editor: Select the correct property from the dropdown that appears after clicking the underlined error text.
- Delete and retype the property name manually: Type the property name exactly as it appears in the database header to force Notion to re-index it.
- Rename the property back to its original name: If you changed the property name after writing the formula, rename it back, then update the formula before changing it again.
Why Notion Shows “Cannot Find Property” in a Formula
Notion formulas reference properties by their internal ID, not by the display name you see in the table header. When you rename a property, the internal ID stays the same, but the formula editor may fail to map the new display name to that ID. This also happens when you copy a database or duplicate a property — the formula may point to a property that no longer exists in the current database schema. The error is not a bug; it is a mismatch between the property name in the formula text and the property list that Notion maintains for that database.
Common Scenarios That Trigger the Error
The error appears most often in these situations:
- You renamed a property after writing a formula that references it.
- You deleted a property that a formula still uses.
- You copied a database page or template that contains a formula referencing a property from the source database.
- You manually typed a property name in the formula editor instead of selecting it from the autocomplete list.
Steps to Fix a “Cannot Find Property” Error in Notion Formulas
Follow these steps in order. Start with Step 1; if the error persists, move to Step 2.
- Click the underlined property name in the formula editor
Open the database page or table view that contains the broken formula. Click the formula cell and select Edit formula from the menu. In the formula editor, find the property name that is underlined in red. Click that property name. A dropdown list of all available properties appears. Select the correct property from the list. Notion replaces the old reference with the current property name. Click Done to save. - Delete and retype the property name manually
If clicking the property name does not show a dropdown, select the entire property name text in the formula editor and press Delete. Type the property name exactly as it appears in the database column header. As you type, Notion should show an autocomplete suggestion. Select the suggestion and click Done to save. - Rename the property back to its original name
If you renamed the property after writing the formula, rename it back to the name that was used when the formula was created. Open the database, click the property header, and select Rename. Enter the original name. The formula should now resolve. After the formula works, rename the property to the new name, then immediately click the property reference in the formula editor and select it again from the dropdown. - Check for deleted properties in the formula
If you deleted a property that the formula references, the error will persist until you remove that reference. Open the formula editor. Look for any property name that is underlined in red and does not appear in your database columns. Replace that reference with a current property, or remove the line that uses it. Click Done to save. - Refresh the database by toggling the view
Sometimes the formula editor cache is stale. Close the formula editor. Switch the database view to a different layout, such as from Table to Board, then switch back. Open the formula editor again. The error may clear after the view refresh.
If Notion Still Shows the Error After the Main Fix
Formula references a property from a different database
If your formula uses the prop() function and the property belongs to a related database, make sure the relation property is correctly set up. Open the database that contains the formula. Check that the relation property points to the correct target database. If the target database was renamed or deleted, recreate the relation and update the formula.
Formula was copied from another database
When you copy a database page or a template that contains a formula, the formula may reference properties that do not exist in the new database. Delete the entire formula and rewrite it from scratch using only properties that exist in the current database. Use the autocomplete list to avoid typing errors.
Property name contains special characters or spaces
Notion formulas handle spaces in property names automatically, but some special characters like slashes or parentheses can cause the error. Rename the property to use only letters, numbers, and underscores. Update the formula to match the new name, then rename the property back to the original name if needed.
Database has too many properties
Notion limits the number of properties a database can have. If you have more than 500 properties, the formula editor may fail to load the property list. Delete unused properties until the count is below 500. Then reopen the formula editor and select the correct property from the dropdown.
Notion Formula Reference Methods Compared
| Method | How It Works | When to Use |
|---|---|---|
| Click property name in editor | Opens a dropdown list of all current properties | Property exists but formula uses an old name |
| Type property name manually | Triggers autocomplete after typing a few characters | Dropdown does not appear or property was recently added |
| Rename property back | Temporarily restores the original property name | Property was renamed after the formula was written |
Notion formulas require exact property references to calculate correctly. The steps above cover the most common causes of the “Cannot find property” error. After fixing the reference, always test the formula with a few pages to confirm it returns the expected value. For complex formulas with multiple property references, check each reference one at a time. To avoid this error in the future, always update your formulas immediately after renaming or deleting a property.