What Are Calculation Properties?
If you're working with HubSpot Pro or Enterprise, you've got access to some seriously powerful tools. One of the most underrated features? Calculation properties. These aren't your typical custom properties. They're dynamic fields that automatically perform math on your existing data, saving your team time and reducing human error.
Think of calculation properties as your personal spreadsheet wizard living inside HubSpot. Need to subtract sales tax from a deal amount? Calculate commission? Figure out days since last contact? Calculation properties handle all that without you lifting a finger.
Why You'll Love Calculation Properties
- Automatically update based on other field values
- Reduce manual data entry and errors
- Create a clearer picture of your deal metrics
- Save hours of spreadsheet work every month
- Keep your data consistent across all deals
How To Create Your First Calculation Property
Step 1: Navigate To Properties
Log into HubSpot and click the gear icon in the top right corner. Scroll down and select Data Management, then Properties. This is where all your property magic happens.
Step 2: Choose Your Object Type
For this example, we're working with deal properties. Click on Deal Properties to get started. You can do this with contacts, companies, or any object that matters to your workflow.
Step 3: Set Up Your Calculation
Click Create Property and select Calculation as your field type. Here's where it gets fun. You'll choose your data type (we'll use Currency for our example), then build your formula.
Step 4: Build Your Formula
Let's walk through a real example: calculating deal amount after sales tax is removed. Start by selecting your first value. In this case, that's your deal Amount field. Then choose your operator:
- Plus sign: adds values
- Minus sign: subtracts values
- Asterisk (*): multiplies values
- Slash (/): divides values
If you're calculating a 5% tax on your deal amount, you'd multiply the Amount by 0.05. Then save that as one property.
Step 5: Create Your Final Calculation
Now create another calculation property that takes your original Amount and subtracts your Tax calculation. This gives you the net amount you're actually taking home. It's clean, it's automatic, and your team gets instant visibility into real deal value.
Real World Use Cases
We love calculation properties because they solve actual business problems. Calculate commissions based on deal size. Figure out how many days a contact has been in your pipeline. Determine revenue per contact. The possibilities are endless, and they all update automatically when your base data changes.
Once you create these properties, you'll see them populate on your deal records instantly. No manual intervention. No spreadsheets. No stress.
That's the power of calculation properties. They're one of those HubSpot features that'll make your team wonder how they ever lived without them.
