Now that we can create calculated Line Item properties, I am trying to create a property that uses the Term in the calculation. However the Term property is a string (eg. P12M) rather than a number. I’ve created a new “Line Item Term in Months” property but does anyone have any suggestions on how to convert the Term into a number? I know how to do it in Excel (using the SUBSTITUTE function) but this isnt available in HubSpot calcualted properties. I tried using the String-to-number function but it doesn’t wok as there are letters in the Term property.
Convert Line Item Term to a number
Related Post
HubSpot Reporting Practical Exercise Not Graded After More Than 24 hoursHubSpot Reporting Practical Exercise Not Graded After More Than 24 hours
So… at least one of my HubSpot Reporting practical exercises has not been graded, and it’s been about 36 hours. I submitted the Create a HubSpot dashboard the day before yesterday
Task – pipeline stage show under CRM /TaskTask – pipeline stage show under CRM /Task
Hi there, I’m a big fan of the task stages feature! Currently, it seems limited to the Customer Success module or the task-specific view. Do you plan to enable this for general
Salesforce to HubSpot MigrationSalesforce 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