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
Hi, I’m Matt!Hi, I’m Matt!
Hi, my name is Matthew (or Matt, I have no preference). I am the Communications Manager for Sigma Alpha Mu Fraternity. I am excited to be able to join this
Forecasting Multiple Product Types on Same DealForecasting Multiple Product Types on Same Deal
In our business, there are two types of pricing models we quote for our deals. Option A might be $50k and Option B might be $100k. By specifying the product types
Show attachment size errors before sending emailShow attachment size errors before sending email
It would be helpful to see before sending an email (both marketing and 1:1 emails) if an attached file is too big to send. Currently the error doesn’t appear until