> For the complete documentation index, see [llms.txt](https://docs.notionapps.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.notionapps.com/screens-and-components/formulas-and-rollups.md).

# Formulas & Rollups

You can show formula and rollup properties on Lists, Details, Forms, and components. Notion still owns the recipe. NotionApps can **recalculate** some of those recipes so Home does not keep a wrong `0` or `0/600` from Notion’s page API.

{% hint style="success" %}
Recalculate in NotionApps Open **Databases → Calculated properties**. Leave **Recalculate in NotionApps** on when the switch is clickable. You do not type a formula here. Full walkthrough: [Recalculate calculated properties](https://docs.notionapps.com/how-to-guides/recalculate-calculated-properties).
{% endhint %}

***

### Recalculate vs Notion’s page value

| Toggle       | What the published app shows                                                                           |
| ------------ | ------------------------------------------------------------------------------------------------------ |
| **On**       | Our eval of Notion’s recipe. After a good compute, Home does not fulfill that field from Notion again. |
| **Off**      | Notion’s raw page API value                                                                            |
| **Disabled** | We cannot evaluate this recipe yet. Notion keeps the number.                                           |

**We can evaluate:** `prop()`, `+` `-` `*` `/`, `if()`, `dateBetween`, and rollups `sum` / `count` / `average` / `min` / `max`.

**Not yet:** `formatDate`, `ifs`, `lets`, `style`, `map`, `filter`, `join`, `empty`, `includes`, `length`, `format`, and other rollup functions.

**Sync from Notion** refreshes the recipe and can load a missing rollup definition. It does not unlock unsupported tokens.

***

## Lists

You can choose to show formula and rollup properties in Lists like List (View Items) screen, List (Update Items) screen, List Component, Page Selector Component, etc.

When Recalculate is **off**, or the field is unsupported, you still need to be aware of this Notion page-API limit:

{% hint style="warning" %}
When you choose a property to view in the lists that is a rollup or formula dependent on a rollup, and if the formula is calculated over more than 25 related pages, Notion provides NotionApps results based on only the top 25 related pages.

For example,

Let's say there are two databases:

* `Projects` and `Tasks`.
* `Projects` has a relation to `Tasks.`
* `Projects` has a rollup property that counts the number of `tasks` linked to a `project`.

Incomplete Data

If a `project` is linked to 30 `tasks (> 25),` NotionApps will only receive the property value as 25 (`incomplete value`).

Complete Data

If a `project` is linked to `10 tasks`, NotionApps will receive `10 (correct value)`.
{% endhint %}

When Recalculate is **on** for `sum` / `count` / `average` / `min` / `max`, NotionApps evaluates from related records we already have, so that 25-page leaf limit does not apply to **our** number. Related rows still have to be synced, and the related database must be shared with the integration.

***

## Components

Rollups & Formulas can be shown in all components.

{% hint style="success" %}
However, for properties where there might be incomplete data`(> 25 related pages)` **and Recalculate is off or unsupported**, we suggest showing them in the Details (View One Item) or Form (Update One Item) screens.

On these screens, when using a "View Text" component to view the property, you will see a refresh button next to it.

On clicking the refresh button, we fetch the complete property data from Notion.
{% endhint %}

We are working with Notion to make this experience better. Meanwhile, if you have questions, please reach out to us via our website chat or email us at <help@notionapps.com>.

***

### Related

* [Recalculate calculated properties](https://docs.notionapps.com/how-to-guides/recalculate-calculated-properties)
* [Why are my rollups showing zero or an incorrect value?](https://docs.notionapps.com/troubleshooting/why-are-my-rollups-on-notionapps-showing-zero-0-value-or-an-incorrect-value)
* [Some rollup properties do not show up in the app builder](https://docs.notionapps.com/troubleshooting/some-rollup-properties-do-not-show-up-in-the-app-builder)
* [16 Sep 2026 Release](https://docs.notionapps.com/release-notes/16-sep-2026-release)
