Salesforce to HubSpot Migration

Hello HubSpot Community,

I have we are migrating our data from salesforce to HubSpot but we are facing issues while mapping salesforce properties to Hubspot as these are not the deafault properties in HubSpot

can you guide us how can we create the following salesforce properties in HubSpot:

Roll-Up Summary (MIN Opportunity)
Roll-Up Summary (MAX Opportunity)
Formula (Text)
Formula (Percent)
Formula (Checkbox)
Lookup(Contact)
Text(15) (External ID) (Unique Case Insensitive)
Formula (Currency)
Lookup(Custom Projects)Lookup Research

For the Roll-Up Summaries, I suggest using the Rollup field type to calculate these. As you’re probably aware the opportunities in SF are deals in Hubspot. You can set the roll up type field as min or max. For the formula fields, you may choose to build equations and logic directly in the property settings using the calculation field type. You can select the appropriate output format (Percent/String) when setting up the fields.

HubSpot uses associations to link records instead of look up fields. During the migration you will need to map the SF contact ID to the HubSpot association ID to the link the two records together. And for Projects and Research you will have create custom objects if not done and then create an associations between contact <> Projects <> Research object. You can enforce unique values in HubSpot to prevent duplicates, acting as an External ID. And select the checkbox that require unique values for the property.

For more info check these out:

Thanks for your reply but when iam creating the Roolup fileds in HubSpot iam not able to select close date of a deal when i select Roll up type as MIN:

Hey @SSharma168 , unfortunately HubSpot roll-up properties currently do not seem to support this method for date properties. I would recommend checking out the workaround outlined in this community conversation https://community.hubspot.com/t5/HubSpot-Ideas/Include-Dates-in-Min-Max-Calculation-Fields/idi-p/773052

I know the workaround has a lot more work involved. However it will get the rollup property to function as you need it to. I hope this help you.

All the best and have great day!