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
ChatGPT Deep Research and HubSpot Marketing: January 21st at 11AMChatGPT Deep Research and HubSpot Marketing: January 21st at 11AM
Webinar Link Have you ever wished you could get real marketing answers from your HubSpot data—without rebuilding reports, exporting CSVs, or spelunking through dashboards until your eyes glaze over?
Understanding the *active* installation requirement for listing an app on Hubspot Marketplace.Understanding the *active* installation requirement for listing an app on Hubspot Marketplace.
Hello everyone,As the title suggests, I am having some trouble increasing the installation count of my App so that it might be eligible for the marketplace listing review process. I
Holding the pipeline in Ticket and Deal viewsHolding the pipeline in Ticket and Deal views
Hello! I am trying to find a way to ‘hold’ the pipeline in CRM views. For instance, we have two Sales Pipelines. I’m trying to keep a view to show ‘All