Fix Notion Formula Cannot Be Copied to New Database: Reference Error

When you try to copy a Notion formula from one database to another, you may see an error message that says the formula cannot be copied due to a reference error. This happens because the formula contains references to properties that do not exist in the target database. The reference error prevents Notion from pasting the formula as-is.

Notion formulas rely on property names, and if a property name in the formula does not match any property in the new database, Notion blocks the paste. This article explains why the error occurs and provides the exact steps to fix it. You will learn how to identify missing properties and adjust your formula so it works in the new database.

Why Notion Blocks a Formula Copy With a Reference Error

Notion formulas are tied to the properties of the database where they were created. When you copy a formula cell and try to paste it into another database, Notion checks whether every property referenced in the formula exists in the target database. If even one property name is missing or spelled differently, Notion shows a reference error and refuses to paste.

This behavior is by design. Notion cannot guess which property in the new database should replace a missing reference. For example, a formula that uses prop("Due Date") will fail if the new database has a property called Deadline instead. The error protects you from accidentally breaking the formula logic.

What a Reference Error Looks Like

When you paste the formula, Notion displays a red border around the cell and a tooltip with text similar to: “Cannot paste: formula references a property that does not exist in this database.” The formula does not appear in the cell. You cannot edit it in the new database until you resolve the missing property references.

Steps to Fix a Notion Formula Reference Error When Copying to a New Database

Follow these steps to identify the missing properties and make the formula work in the target database.

1. Open the source formula
   In the original database, click the formula cell and then click the formula text in the property pane on the right side of the window. Notion opens the formula editor showing the full formula text.
2. Copy the formula text to a temporary file
   Select the entire formula text in the editor and press Ctrl + C. Open a plain text editor such as Notepad and paste the formula with Ctrl + V. You will edit this text before pasting it into the new database.
3. List all property names used in the formula
   Scan the formula text for every occurrence of prop("Property Name"). Write down each property name exactly as it appears, including spaces and capitalization. For example, if the formula contains prop("Start Date") and prop("End Date"), those are the two names you need.
4. Open the target database and check existing properties
   Navigate to the new database. Click the database title at the top of the page and select Properties from the menu. Compare the list of property names with the list you wrote down.
5. Add any missing properties to the target database
   For each property name that is missing, click Add a property at the bottom of the properties list. Type the exact property name from the source formula. Choose a property type that matches the original — for example, use Date if the original was a date property. Notion formulas only require the property name to match; the type can be different, but matching the type avoids unexpected results.
6. Copy the formula from the temporary file into the new database
   Select the formula text in Notepad and press Ctrl + C. In the target database, add a new formula property or click an existing formula cell. Open the formula editor and press Ctrl + V. Notion now accepts the paste because all referenced properties exist.
7. Test the formula with a sample row
   Fill in values for the referenced properties in at least one row. Verify that the formula returns the expected result. If the result is an error, double-check that each property name in the formula matches exactly.

What to Do If the Formula Still Shows an Error After Adding Properties

If you added all missing properties and the formula still does not work, the issue is likely a hidden character or a spelling mismatch. Follow these troubleshooting steps.

Formula References a Rollup or Relation Property That Exists but the Relation Is Broken

If the formula uses prop("Related Project") where Related Project is a relation property, the target database must also have a relation property with that exact name. However, a relation property must be linked to another database. If the target database does not have the same linked database, the formula may still fail. Create the relation property in the target database and link it to the correct database before pasting the formula.

Property Name Has a Trailing Space or Invisible Character

Open the source database and select the property name in the properties list. Copy the name and paste it into a plain text editor. Compare it character by character with the name in the target database. If you see a trailing space, remove it from either the source or the target. Then update the formula text in your temporary file accordingly.

Notion Formula Reference Error: Source vs Target Database Comparison

Item	Source Database	Target Database
Property names in formula	Due Date, Priority, Assignee	Missing Priority, missing Assignee
Formula text	prop(“Due Date”) + prop(“Priority”)	Empty formula cell
Result after paste	Works	Reference error
Fix required	None	Add Priority and Assignee properties

After adding the missing properties, the formula pastes correctly and returns the same values as in the source database.

How to Avoid Reference Errors When Copying Formulas in the Future

The simplest way to avoid reference errors is to create the target database by duplicating the source database. Right-click the database name in the sidebar and select Duplicate. Then delete rows you do not need. Duplicating preserves all properties and formulas exactly, so no reference error occurs.

If you must create a new database from scratch, plan its properties before writing any formulas. List the properties you need and create them in the new database first. Then write the formula or copy it from another database. This approach ensures that every property name exists before you paste the formula.

You can also use Notion’s template button feature to copy a database structure with formulas intact. Create a template button in the source database that includes a pre-built row with the formula. When you click that button in the target database, Notion creates a new row with the formula and properties already in place.