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
Data Audit/Hygiene Reports for Contacts, Companies, Leads, Deals, etc.Data Audit/Hygiene Reports for Contacts, Companies, Leads, Deals, etc.
Hello! I want to create a weekly report that lists newly created Contacts, Companies, Leads, Deals, etc. and the properties that we have/don’t have. For example, an inbound email will create
Losing all our Demo meeting scheduler links and related workflows when our Sales Coordinator leaves.Losing all our Demo meeting scheduler links and related workflows when our Sales Coordinator leaves.
One of our most successful lead gen processes is ‘book a demo/pilot,’ which depends on MEETING SCHEDULER links. I have built out about 7 different ones, used for different geographies,
Content creation frameworkContent creation framework
Before taking this course I knew nothing about content framework but now I’ve an idea of it.