What This Update Actually Is
HubSpot added two new formula creation modes inside the Custom Report Builder. They sit alongside the existing syntax-based formula tab as separate options.
The first mode is Conditional Logic. It walks you through building if/else formulas using a guided interface. No syntax. No hunting for the right operator. You pick conditions and outcomes from structured inputs.
The second mode is Summary Measure. It lets you create aggregations on a measure through the same kind of guided interface. Think: totals, averages, counts, and other rollups without needing to know the formula syntax by heart.
One important caveat to know upfront: if you start building in one tab and switch to another, HubSpot will warn you that your in-progress work won't carry over. The three modes don't translate to each other yet. Commit to your approach before you start.
Why HubSpot Shipped This
Formula syntax in the CRB is powerful. It's also intimidating. We've seen this pattern across hundreds of portals: the report builder gets opened, the Formulas section gets noticed, and then humans either write something wrong and give up or avoid it entirely.
Even HubSpot's AI-assisted formula option doesn't always land the way you expect it to. Prompting an AI for a specific aggregation across a filtered dataset takes trial and error. For ops-minded humans who just want a clean if/else rule or a quick sum, that's friction that doesn't need to exist.
These two guided modes lower the floor on custom reporting without touching the ceiling. Experienced report builders can keep writing raw syntax. Everyone else now has a usable on-ramp.
How to Use It Step by Step
- Go to the Custom Report Builder inside HubSpot Reporting.
- In the chart configuration panel, scroll to the Formulas section at the bottom and click Add+.
- You'll see three tabs: Formula (the original syntax mode), Conditional Logic, and Summary Measure.
- For an if/else formula, click Conditional Logic. Use the guided inputs to set your condition, the value to return when true, and the value to return when false.
- For an aggregation, click Summary Measure. Select the measure you want to aggregate and choose the aggregation type (sum, average, count, etc.) from the dropdown.
- Name your formula, save it, and add it to your chart as you would any other measure.
- Remember: don't switch tabs mid-build. Pick your mode first, then build. Any in-progress work on one tab won't transfer if you switch.
What It Touches in Your HubSpot Strategy
This update sits inside Reporting, but its ripple is much wider. Any hub that your team uses for custom reporting is now easier to report on with precision. That covers Marketing, Sales, Service, Content, Data Hub, Commerce Hub, and Smart CRM.
For RevOps humans, this changes how quickly you can build the calculated fields your stakeholders keep asking for. Conditional buckets for deal size, lead score tiers, weighted pipeline values: all of these have traditionally required either syntax confidence or a workaround property. Now you build them directly in the report.
For marketing ops, Summary Measure is especially useful for contact-level and campaign-level aggregations that used to require exporting to a spreadsheet.
Key Takeaway
Conditional Logic in the CRB removes the need to memorize if/then formula syntax. If your team has been avoiding custom formulas because the syntax felt too technical, this is the feature that unlocks it.
One place to be thoughtful: your portal's data foundation matters here. Guided formula modes make it easier to build formulas, but a formula built on messy or inconsistent property data will still return messy results. If your CRM data hygiene isn't solid, this update won't fix that.
If you're not sure where your portal data stands, our HubSpot portal audit checklist is a good starting point before you start layering in complex formulas. And if you want to pair this with AI-powered data exploration, check out how HubSpot's Data Agent now queries your entire CRM in a single prompt for a complementary approach to surfacing insights.
Key Takeaway
Summary Measure aggregations reduce the need to export report data into Excel or Google Sheets for basic rollups. That's time back for the humans doing the analysis.
One more note on integrations: if your team uses Data Hub or has third-party data syncing into HubSpot, these guided formula modes work on those data sources too, as long as the data is mapped to properties inside HubSpot. Nothing changes about what data is available; what changes is how easily you can calculate across it.
Who Should Care Most
This update matters most to the following humans and teams:
- RevOps managers and HubSpot admins who build custom reports for leadership but aren't comfortable with formula syntax. Guided modes cut build time significantly.
- Marketing ops professionals who need campaign-level aggregations or segmented performance views without exporting data.
- Sales managers who want conditional deal classification in reports (e.g., tier a deal as "high value" vs. "standard" based on amount) without needing a developer.
- Growing companies on Professional tiers who don't have a dedicated data analyst. These modes make custom reporting accessible to the whole team.
- Veteran HubSpot users who already know the syntax. You don't lose anything here. You just get faster options for simpler formulas.
If you're on Free or Starter, this update isn't available to you yet. The CRB with formula support is a Professional and Enterprise feature.
George's Take
I've watched talented marketers and sales managers open the Custom Report Builder, get to the Formulas section, and completely freeze. They know what question they want to answer. They just don't know the syntax to ask it. That's not a knowledge problem; it's a design problem. HubSpot just fixed the design. Conditional Logic and Summary Measure won't replace deep formula knowledge for complex use cases, but they'll let the rest of your team stop waiting on the one person who has it. That's the kind of change that lets organizations flourish at scale.
“When more humans on your team can ask real questions from your data without needing a translator, your whole organization gets smarter faster.”
If this update makes you want to dig deeper into how your reporting data flows across hubs, this piece on why shared HubSpot data is the quiet superpower most teams never unlock is worth your next 10 minutes.
Ready to build a reporting setup that actually answers your business questions? Let's look at your portal together. Book a free strategy call with the Sidekick team and we'll show you exactly where your reporting has gaps and how to close them fast.
Frequently Asked Questions
What is Conditional Logic in HubSpot's Custom Report Builder?
Conditional Logic is a guided formula mode in the HubSpot Custom Report Builder that lets you build if/else formulas without writing syntax. You set a condition, a value to return when that condition is true, and a value to return when it's false, all through structured inputs. It's currently available in public beta for Professional and Enterprise tiers.
What is the Summary Measure option in the HubSpot CRB?
Summary Measure is a guided formula mode that lets you create aggregations on a data measure, such as sums, averages, and counts, without needing to write formula syntax. You select your measure and choose an aggregation type from a dropdown menu. It's designed for humans who need quick rollups inside custom reports.
Can I switch between the Formula, Conditional Logic, and Summary Measure tabs mid-build?
No, not without losing your work. If you start building in one tab and switch to another, HubSpot will show a warning that your in-progress formula won't carry over. The three modes don't translate between each other yet. You should choose your approach before you start building.
Which HubSpot plans get access to Conditional Logic and Summary Measure in the CRB?
This feature is available for Professional and Enterprise tiers across Marketing Hub, Sales Hub, Service Hub, Content Hub, Commerce Hub, Data Hub, and Smart CRM. It's currently in public beta, meaning all accounts at those tiers have access. Free and Starter tiers don't have access to formula features in the Custom Report Builder.
Do I still need to know HubSpot formula syntax with these new modes?
Not for simpler use cases. Conditional Logic and Summary Measure handle the most common formula scenarios through guided inputs. If you need highly complex, multi-variable formulas, the original syntax tab is still there and still the most powerful option. The new modes add accessibility without removing depth.
Will these guided formula modes work with third-party data synced into HubSpot?
Yes, as long as the data is mapped to properties inside HubSpot. The guided modes work on any data source available in the Custom Report Builder, including data synced through Data Hub or native integrations. The quality of your formulas will still depend on the consistency and accuracy of the underlying property data.
