# Lookup and Rollup on Custom Objects? **URL:** \ **Category:** CRM\ **Tags:** crm, object\ **Created:** [June 10, 2023, 4:07pm UTC](https://community.hubspot.com/t/lookup-and-rollup-on-custom-objects/83102 "2023-06-10T16:07:56Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![nychd](https://avatars.discourse-cdn.com/v4/letter/n/a9adbd/32.png) [@nychd](https://community.hubspot.com/u/nychd)\ **Post date:** [June 10, 2023, 4:07pm UTC](https://community.hubspot.com/t/lookup-and-rollup-on-custom-objects/83102/1 "2023-06-10T16:07:56Z")
Does Hubspot CRM have any sort of way to do rollups and/or lookups with custom objects? All my research seems to suggest not, but I find it hard to belive. Trying to convince myself to use Hubspot as a CRM along with marketing, but if this is the case it’s a non-starter. ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [June 10, 2023, 4:25pm UTC](https://community.hubspot.com/t/lookup-and-rollup-on-custom-objects/83102/2 "2023-06-10T16:25:54Z")
Hi @nychd, It depends on how exactly you want this to work but generally, yes. Calculation properties let you count or sum up property values of the same object or of associated objects, including custom objects. > **[Create calculation and rollup properties](https://knowledge.hubspot.com/properties/create-calculation-properties)** > > Learn how you can create calculation, time since, time between, time until, or rollup properties in HubSpot based on property values. If you share a bit more details, I’ll happily share a screenshot of what it could look like. Best regards! ---
**Author:** ![nychd](https://avatars.discourse-cdn.com/v4/letter/n/a9adbd/32.png) [@nychd](https://community.hubspot.com/u/nychd)\ **Post date:** [June 10, 2023, 5:11pm UTC](https://community.hubspot.com/t/lookup-and-rollup-on-custom-objects/83102/3 "2023-06-10T17:11:30Z")
Hi Karsten, That was very helpful thanks! It seems like that plus the [concept of association](https://knowledge.hubspot.com/crm-setup/associate-records) covers a lot of what we’d need. We have a object called “location” that tracks all the physical stores owned by an company. Each location is associated with a company. There are two things I’d want to do that I’m trying to understand how they would work in Hubspot: - Pull a feild called “brand” from the company object and show it on the location object. (in Salesforce we’d use a lookup field). - Have a field called “most common state” on the company object that looks at all the associated store objects and determines which “state” field is most frequently used in associated stores. (In Salesforce I can’t do this declaratively without using a extension like DLRS) ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [June 11, 2023, 10:22am UTC](https://community.hubspot.com/t/lookup-and-rollup-on-custom-objects/83102/4 "2023-06-11T10:22:10Z")
Hi @nychd, There is a new product update (public beta) which allows for using formulas: > * * * > > Settings > > ### [Public Beta] Calculated Properties: Advanced Formula Builder > > 8. Juni 2023 > > ### **What is it?** > > The advanced formula builder for calculated properties is a powerful tool that allows you to take your data and turn it into vital business context with ease. You can now create custom number formulas and calculations to suit your specific business needs. > > ### **Why does it matter?** > > Whether you’re analyzing sales data, tracking customer behavior, or measuring the effectiveness of your marketing campaigns, the advanced formula builder can help you gain deeper insights and make informed decisions. > > With its advanced capabilities, the advanced formula builder makes it easy for both novice and experienced users to transform raw data into actionable insights. > > ### **How does it work?** > > In your HubSpot account, navigate to **Settings \> Properties** > > Select the needed object from the **Select an object:** dropdown. > > Then select **Create Property** > > Within the property creation flow, select “Calculation” as the Field Type. Next select the “_Build Calculation_” button. > > Select the “_Custom Calculation_” from the Calculated Property Type dropdown. Once selected, toggle on “Advanced Mode” to build your number formula. > > Enter your needed formula in the formula editor and click the Create button to create the property. > > ### **Who gets it?** > > CMS Enterprise, CMS Pro, Marketing Enterprise, Marketing Pro, Ops Enterprise, Ops Pro, Sales Enterprise, Sales Pro, Service Enterprise, Service Pro > > * * * ---
**Author:** ![PVasani](https://avatars.discourse-cdn.com/v4/letter/p/919ad9/32.png) [@PVasani](https://community.hubspot.com/u/PVasani)\ **Post date:** [November 16, 2023, 6:37am UTC](https://community.hubspot.com/t/lookup-and-rollup-on-custom-objects/83102/5 "2023-11-16T06:37:55Z")
Hello @karstenkoehler , Can you please help me how can this be used as Lookup field ? We want to map the property of Hubspot with Salesforce Lookup (Reference) field. Thanks and Regards, Ishan