Fix Notion Rollup Aggregation Type Cannot Be Changed Mid-View

You are editing a Notion database and the Rollup property shows a grayed-out aggregation type dropdown. You cannot switch from Count to Sum or from Average to Max. The dropdown is locked, and clicking it does nothing. This happens because Notion locks the aggregation type once the rollup has been configured and saved in a view. This article explains why the rollup aggregation type is locked and provides the exact steps to change it without losing your data.

Why the Rollup Aggregation Type Is Locked

Notion treats the rollup property as a calculated field. When you first create a rollup, you select a relation property, a target property from the related database, and an aggregation type. Once you click outside the property editor or save the database, Notion commits that configuration. The aggregation type dropdown becomes read-only because Notion stores the aggregation formula as part of the property schema. Changing the aggregation mid-view would require Notion to recompute every row in the database, which can cause performance issues and data inconsistency. Instead of allowing edits, Notion forces you to delete and recreate the rollup property.

What the Aggregation Type Controls

The aggregation type determines how Notion combines values from related records. For example, Sum adds all numeric values from the related records. Average calculates the mean. Count tallies the number of related records. Max and Min return the highest or lowest value. Each type uses a different calculation engine internally. Notion locks the type to prevent conflicts between the stored formula and the displayed results.

When the Lock Appears

The lock appears immediately after you finish creating the rollup property. Even if you have not added any rows, the aggregation type cannot be changed without deleting the property. The lock also persists across all views of the database. Switching from table view to gallery view does not unlock the dropdown.

Steps to Change the Rollup Aggregation Type

To change the aggregation type, you must delete the existing rollup property and create a new one with the correct aggregation. Follow these steps exactly.

1. Open the database property menu
   Hover over the column header of the rollup property in table view. Click the downward arrow that appears to open the property menu. If you are using a gallery, board, or list view, click the property name in the property panel on the right side of the screen.
2. Delete the rollup property
   Scroll to the bottom of the property menu. Click Delete. A confirmation dialog appears. Click Delete again. The rollup property and all its values disappear from the database. This does not delete any data from the related database. The rollup values were computed on the fly and are not stored permanently.
3. Add a new rollup property
   Click the + button in the last column of the table view. Alternatively, open the property panel and click Add a property. Type a name for the new rollup property. Select Rollup from the property type list.
4. Configure the relation and target property
   In the rollup configuration window, select the same relation property that the original rollup used. Then select the same target property from the related database. The target property should be the same field you used before to maintain consistency.
5. Choose the new aggregation type
   Click the Calculate dropdown. Select the aggregation type you want, such as Sum, Average, Count, Max, or Min. The dropdown is fully editable at this point because you are creating a new rollup.
6. Save the new rollup
   Click anywhere outside the configuration window or press Escape. The new rollup property appears with the correct aggregation type. Your database now shows the recalculated values.

If the Rollup Is Used in a Filtered View

If your database has a filtered view that uses the rollup property as a filter condition, deleting the rollup causes the view to show an error. The view may display a message that the property is missing. To avoid this, remove the rollup from the filter before deleting the property.

1. Open the view filter menu
   Click the view name at the top of the database. Select Filter from the dropdown menu.
2. Remove the rollup filter condition
   Find the filter condition that uses the rollup property. Click the X next to that condition to remove it. If the rollup is the only condition, click Clear all filters.
3. Delete and recreate the rollup
   Follow the steps in the previous section to delete the rollup property and create a new one. After recreating the rollup, reopen the filter menu and add the filter condition with the new rollup property.

Common Issues After Recreating a Rollup

Rollup Shows No Values After Recreation

If the new rollup shows blank cells, the relation property may not be linking to the correct records. Open the relation column and verify that each row has a related record selected. If the relation is empty, the rollup has nothing to calculate. Add related records to the relation property.

Rollup Displays Wrong Aggregation Result

If the rollup shows unexpected numbers, the target property may contain mixed data types. For example, if the target property is a text field with some numeric values, Sum and Average will ignore non-numeric values. Change the target property to a number or date type to ensure correct aggregation.

Rollup Aggregation Type Still Locked After Recreation

If the dropdown is grayed out again immediately after creating the new rollup, you accidentally clicked outside the configuration window before selecting the aggregation type. Delete the rollup again and recreate it. This time, select the aggregation type before clicking anywhere else.

Rollup Aggregation Types Compared

Aggregation Type	What It Calculates	Best Used For
Count	Number of related records	Counting tasks, contacts, or items linked to each row
Sum	Total of all numeric values in the target property	Adding up expenses, hours, or scores from related records
Average	Mean of all numeric values in the target property	Calculating average ratings, test scores, or temperatures
Max	Highest numeric or date value in the target property	Finding the latest deadline or the highest price among related items
Min	Lowest numeric or date value in the target property	Finding the earliest start date or the lowest cost

You can now change any locked rollup aggregation type in your Notion database. Delete the old rollup property, recreate it with the correct aggregation, and adjust any filters that reference the rollup. For advanced use, consider using a formula property with the prop() function to combine rollup results with other calculations. This approach gives you more control over how rollup values are displayed.