Fix Notion Rollup Number Format Reverts on Database Schema Edit

You set a rollup property in a Notion database to display a number with a specific format such as currency, percentage, or decimal places. When you edit the database schema by adding, renaming, or reordering a property, the rollup format reverts to the default plain number. This happens because the rollup property loses its custom format configuration during the schema refresh triggered by the edit. This article explains why the format resets and provides the exact steps to preserve or quickly restore the format after a schema change.

Why the Rollup Number Format Resets on Schema Edit

A rollup property in Notion pulls data from a related database and can apply an aggregation function such as Sum, Count, or Average. When you set a custom number format like Currency or Percent, Notion stores that format as a property-level setting. Editing the database schema triggers a re-evaluation of all rollup properties in that database. During this re-evaluation, the custom format is not retained and reverts to the default Number format with no decimal places.

The root cause is that Notion treats the rollup format as a volatile attribute. Any change to the schema, including adding a new property, renaming an existing property, or changing a property type, causes the rollup to refresh. The format setting is not preserved across this refresh. This behavior is by design, though it is not documented by Notion.

What Counts as a Schema Edit

The following actions trigger the format reset:

• Adding a new property to the database
• Renaming any property
• Changing the type of any property (for example, from Text to Number)
• Reordering properties in the table view
• Deleting a property

Steps to Restore the Rollup Number Format After a Schema Edit

The only direct fix is to reapply the format after each schema edit. Use the steps below to restore the format quickly.

1. Open the database view
   Navigate to the database that contains the rollup property with the lost format. Click anywhere inside the database to select it.
2. Click the rollup property header
   Find the column header of the rollup property. Click the header name to open the property menu.
3. Select Edit property
   From the dropdown menu, click Edit property. The property settings panel opens.
4. Set the number format
   In the property settings panel, locate the Format section. Click the format dropdown and select the desired format such as Currency, Percent, or Number with decimal places. If you need a custom number of decimal places, choose Number and then set the decimal places using the plus and minus buttons.
5. Close the property panel
   Click Close or press Escape to save the change. The rollup values now display with the chosen format.

Alternative Method: Use a Formula Property to Bypass Format Loss

If you frequently edit the database schema, consider using a formula property to display the rollup value as a formatted string. Formula properties do not lose their code when the schema changes. This method adds an extra column but eliminates the need to reapply the format.

1. Create a formula property
   In the database, add a new property and set the type to Formula.
2. Write the format formula
   In the formula editor, enter a formula that converts the rollup value to a formatted string. For example, to show a rollup named “Total Cost” as currency, use format(prop("Total Cost")) for a plain number string. For two decimal places, use format(round(prop("Total Cost") 100) / 100) and prefix with a dollar sign: "$" + format(round(prop("Total Cost") 100) / 100).
3. Test the formula
   Click Done to save the formula. The formula column displays the rollup value as a text string with your custom formatting. This format does not reset when you edit the database schema.

If Notion Still Has Issues After the Main Fix

Rollup Property Shows Incorrect Aggregation After Format Change

If the rollup value itself appears wrong after reapplying the format, the underlying relation or rollup configuration may have been altered by the schema edit. Check the relation property that the rollup depends on. Open the relation property settings and confirm that the correct database and property are selected. Re-select them if needed.

Formula Property Returns an Error

If you use the formula workaround and the formula shows a red error message, check the property name in the formula. Renaming a property after writing the formula will break the reference. Update the formula to use the new property name. Also ensure that the rollup property name is spelled exactly as it appears in the database.

Format Resets on Every Browser Refresh

If the format resets without any schema edit, this indicates a sync issue. Log out of your Notion account and log back in. Clear your browser cache and reload the page. If the problem persists, try accessing the database from a different browser or the Notion desktop app.

Rollup Format Methods Compared

Item	Direct Rollup Format Setting	Formula Property Workaround
Format retention on schema edit	Resets to default Number	Retains formula code
Setup complexity	Simple, one-click dropdown	Requires writing a formula
Supports currency symbol	Yes, built-in Currency format	Yes, manual string concatenation
Supports decimal places	Yes, configurable in Number format	Yes, using round() and format()
Output type	Number (usable in calculations)	Text string (not usable in calculations)

You can now restore the rollup number format after any database schema edit by reapplying the format in the property settings. If you edit the schema often, create a formula property that formats the rollup value as a string to avoid repeated manual fixes. For advanced usage, combine the formula with conditional logic using the if() function to show different formats based on other property values.