Formula Fields in Custom Report Builder

Marketing HubSales HubService HubEnterpriseLive

What it is

The Formulas feature in the Custom Report Builder (CRB) allows you to create calculated fields directly within your reports. Key capabilities include: Integrated Builder: Easily locate the "Create Formula" button in the middle configuration panel to start building. All created formulas will be hosted in this section. Note: You can create up-to 5 formulas per report. Formula Assistant & AI: Access a library of common formulas, use AI assistance for building, example guide for creating formulas and utilize a real-time preview table to see your results as you work. Seamless Reporting: Use your custom formulas just like any other property—add them as report columns, apply them as filters, or use them to drill down into specific data points. Enum data type properties Note: For these data type properties which generally display dropdown options, there is a known limitation where their internal ID is being used instead of the user label if you were to display them as part of the formula, reference them in the formula or filter the formula. Drilldown Note: Clicking on the the formula field to drill down to see the table may result in different number of rows being shown than what you clicked on. This is because any filters applied on the report may be ignored once you drill into the formula field value resulting in more rows being shown. The experience for Formula fields has been updated from the public beta but you can see the demo of the core feature and use cases in action in the public beta version for Formula fields here: Loom demo

Why it matters

Turning raw data into insights often required work outside HubSpot. Formulas remove that friction, so you can calculate values like conversion rates, adjusted revenue, or discounts—without exporting to spreadsheets.

Produced by Value-First Media