⚛️Formulas & Rollups

Formulas

If the formula is simple, it is supported across all builder configurations on NotionApps.

A simple formula is a formula that does not have the dependency on a Rollup or a Relation property.

However, formulas that depend on Rollups or Relations are currently only supported in the "Text" component.

If the formula has a dependency on Rollups or Relations and is used in the "Text" component, you will find an option to refresh the data using the refresh button next to the "Text" component. Refer to the image below.

Rollups

Rollup properties are currently only supported in view components like Text, Heading, Image Viewer, File Viewer, etc.

If a Rollup is used in the "Text" component, you will find an option to refresh the data using the refresh button next to the "Text" component. It will look similar to what is shown in the above image.

Support for formulas & rollups on list screens

TL: DR; As a workaround on list screens, we suggest going to the related database's property through the property selection dropdown and directly picking up the desired property. For example, filter all projects where project → tasks → status = Pending.

When we pull your data from Notion, we get limited information for complex formulas and rollups calculated only over the top 25 related pages. Because of this, we don't allow showing these properties on the list screens as it might show inaccurate information.

However, we are working on providing this capability. This should be available soon.