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
Unable to complete Practical ExercisesUnable to complete Practical Exercises
Hi there,I have nearly completed the Service Hub Software Certification programme, but I cannot access the Practical Exercises and keeps hitting me with a pay-wall. How can I complete this?
Excited to networkExcited to network
Hello Everyone!Looking to connect with others in sales enablement who are using HubSpot to drive adoption and revenue. Open to sharing what’s working and learning from your approaches.
Product BundlesProduct Bundles
I found some threads on this topic but never really found an answer. We are hoping there is a way to add a “bundle” of products to a quote. We’d essentially