Formulas in Notion can have high levels of complexity beyond what the API can compute in a single request. For
formula property values that exceed have or exceed depth of 10 referenced tables, the API will return a "Formula depth" error as a
As a workaround, you can retrieve the
formula property object from the Retrieve a Database endpoint and use the formula expression to compute the value of more complex formulas.
Due to the encoded cursor nature of computing rollup values, a subset of aggregation types are not supported. Instead the endpoint returns a list of all property_item objects for the following rollup aggregations:
show_unique(Show unique values)
unique(Count unique values)
A page property of type
formula can involve computing a value based on the properties in another
relation page. As such the integration needs permissions to the other
relation page. If the integration doesn't have permissions page needed to compute the property value, the API will return a
"object_not_found" error specifying the page the integration lacks permissions to.
If a property value involves pagination and the underlying properties or pages used to compute the property value change whilst the integration is paginating through results, the final value will impacted and is not guaranteed to be accurate.