When you try to delete a property from a Notion database, you may see the error message “Property Cannot Be Deleted” and the option is grayed out. This happens because the property is currently being used as a filter in a database view. Notion prevents deletion of any property that is referenced by an active filter, sort, or group in any view of that database. This article explains why this error occurs and provides the exact steps to remove the filter so you can delete the property.
Key Takeaways: Removing a Property Blocked by an Active Filter
- Database view filter check: Open each view of the database and inspect the filter bar to find which filter uses the property.
- Clear or remove the filter condition: Click the filter condition and choose “Clear” or delete the entire filter rule to release the property.
- Delete the property after removing all references: Once no view has an active filter on that property, the “Delete Property” option becomes available in the database properties menu.
Why Notion Blocks Deletion of a Property Used in a Filter
Notion databases allow you to create multiple views of the same data, each with its own filters, sorts, and groups. When you add a filter condition that references a specific property, Notion records that property as “in use” by that view. The application prevents deletion of any property that is currently referenced by any view’s filter, sort, or group. This is a safety measure: deleting the property would break the filter logic and could cause unexpected behavior or data loss in the view. The same restriction applies if the property is used in a formula, rollup, or relation that depends on it. However, the most common cause of the “Property Cannot Be Deleted” error is an active filter in one or more views.
Steps to Remove the Filter and Delete the Property
- Open the database and identify all views
Navigate to the database that contains the property you want to delete. Look at the tabs at the top of the database. Each tab represents a different view. Click each view one by one to inspect its filter settings. - Check the filter bar in each view
In each view, look at the top of the database area. If a filter is active, you will see a filter bar with one or more filter conditions. The filter bar shows the property name used in each condition. If you see the property name you want to delete, that filter is blocking deletion. - Clear the filter condition that uses the property
Click the filter condition that references the property. A dropdown menu appears. At the bottom of the dropdown, click “Clear” to remove that specific condition. Alternatively, if you want to remove the entire filter, click the “X” icon on the far right of the filter bar. Confirm that the filter bar disappears. - Repeat for every view
Go through all views of the database. If any view has a filter using the property, you must clear it. Also check if the property is used in a sort or group. Click the sort or group button and remove any reference to the property. Notion may also block deletion if the property is used in a linked database view, so check linked databases that reference this database. - Delete the property
Return to the database properties menu. Click the three-dot icon at the top right of the database and select “Properties.” Find the property you want to delete. Hover over it and click the three-dot icon next to the property name. Select “Delete Property.” Confirm the deletion in the pop-up dialog.
If Notion Still Blocks Deletion After Clearing Filters
Property is used in a formula or rollup
If the property is referenced by a formula, rollup, or relation in another property, you must remove that dependency first. Open the properties menu. Look for any property that contains a formula referencing the blocked property. Delete or edit that formula to remove the reference. Then try deleting the original property again.
Property is used in a linked database view
Linked database views in other pages can also block deletion. Go to the page that contains the linked view of your database. Open the linked view and check its filter bar. Clear any filter that uses the property. After removing all linked view references, return to the original database and delete the property.
Property is used in a template or automation
If your database has templates or Notion Automations that reference the property, those can also prevent deletion. Open the database templates. Edit each template and remove any mention of the property. Also go to Settings & Members > Automations and delete any automation that uses the property. Then retry deletion.
| Item | Active Filter | Formula/Rollup Dependency |
|---|---|---|
| Cause of block | Property is used in a filter condition in any view or linked view | Property is used in a formula, rollup, or relation property |
| Where to check | Filter bar in each view and linked database views | Properties menu, look for formulas or rollups referencing the property |
| Fix action | Clear the filter condition or remove the entire filter | Edit or delete the formula/rollup property that references the blocked property |
| Time to resolve | 1-2 minutes per view | 2-5 minutes per dependency |
Now you can identify which view or dependency is blocking the property and clear it. After removing all references, the “Delete Property” option will be available. To avoid this issue in the future, before creating a filter, consider whether you might want to delete that property later. If you need to keep the filter but also want to remove the property, duplicate the database first and delete the original after migrating data.