Looking to sum the number of deals associated with a company
SOLVE
Hello all, I am hoping to find a workaround for my usecase.
Scenario: I have 3 deals associated with a company. I want to create a numerical property on the company level which will tell me the number of deals that company is associated with.
You can do this through a custom calculation property. Calculation properties require one of Marketing Hub Professional, Sales Hub Professional, Service Hub Professional, Operations Hub Professional, CMS Hub Professional, or higher. See below for how to build the calculation property, that will count the number of deals on a company.
✔️ Was I able to help answer your question? Help the community by marking it as a solution.
There is a default company property called Associated deals which does exactly that: "the number of deals in the HubSpot CRM associated with the company. This is updated automatically by HubSpot."
With a Professional or Enterprise subscription, you could also create a calculation property. This does essentially the same thing but gives you more flexibility. You can see in my screenshot that I filtered for deals from a certain pipeline. The calculation property counts all record with a value in the property chosen, in this case Create date. (And each record comes with a Create date.)
Another way to count certain objects is by workflow (if record meets the enrollment triggers, increase value of property by 1). This can be useful if you've hit the limit of calculation properties in your portal.
Hope this helps!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
There is a default company property called Associated deals which does exactly that: "the number of deals in the HubSpot CRM associated with the company. This is updated automatically by HubSpot."
With a Professional or Enterprise subscription, you could also create a calculation property. This does essentially the same thing but gives you more flexibility. You can see in my screenshot that I filtered for deals from a certain pipeline. The calculation property counts all record with a value in the property chosen, in this case Create date. (And each record comes with a Create date.)
Another way to count certain objects is by workflow (if record meets the enrollment triggers, increase value of property by 1). This can be useful if you've hit the limit of calculation properties in your portal.
Hope this helps!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
Looking to sum the number of deals associated with a company
SOLVE
@karstenkoehler Is there a way to do this count but include deals from multiple pipelines? Also how would I create it for deals within the last calendar year?
You can do this through a custom calculation property. Calculation properties require one of Marketing Hub Professional, Sales Hub Professional, Service Hub Professional, Operations Hub Professional, CMS Hub Professional, or higher. See below for how to build the calculation property, that will count the number of deals on a company.
✔️ Was I able to help answer your question? Help the community by marking it as a solution.