Quick tipHow toSmart CRMData Hub

Calculation properties: build a custom equation in HubSpot

A calculation property computes a value from other properties so nobody has to type it.

Subscription
Professional or Enterprise
Permissions
Edit property settings
Time
5 min · Intermediate
Last verified

Short answer

Create a property with field type Calculation, choose Custom equation, set the output type and format, and write the formula using the editor's Functions and Properties menus. The API can create them too, with field type calculation_equation and a type of number, bool, string or enumeration. Calculation properties need a Professional or Enterprise subscription.

1. The field type

The create property panel in my demo portal lists Calculation next to Rollup and Property sync.

Field type dropdown listing Date picker, Calculation, Rollup, Property sync, File, HubSpot user, URL and Email
Calculation (1).

2. The equation editor

Choosing Calculation shows the calculated property type, output type, number format, and a formula box with a live issue check. I did not save it.

Calculation property settings with Custom equation, Output type Number, Formatted number and a formula editor
Type (1), output (2), and the formula editor (3).

3. Good uses

  • Margins, ratios and per-unit values from existing number fields.
  • Time between two dates, such as days from create to close.
  • For values from associated records, use a rollup. See rollup properties.

Sources

New field notes by email

One email when a new article publishes.

Still stuck?

If this did not fix it, the problem is probably specific to your setup. Book a call and we will look at it together.

Book a call with Sam