@Bareld Yeah, so what i did figure is that you don’t need workflows to calcuate the difference between 2 dates and I think it’s possible to do it even in the Sales Pro plan. What this does need though is yet another custom property for each deal stage that will hold how long the deal is sitting in that stage e.g. “Time spent in Contract Sent”. We can then try to populate that property by calculating the difference between the current date and the date on which the deal entered that stage . At the time of creating this custom property, you need to select the Field Type as “Calculation” and then in the next screen select the Calculated Property Type as “Time Between”.
However, in order to implement this Time Between function, we first need to create one more custom property called Today’s Date (again a basic requirement that Hubspot should be providing for). I am in the process of trying the suggestions here to do that - https://community.hubspot.com/t5/CRM/How-to-create-a-Today-s-date-date-property/td-p/389836.
For those, who missed my earlier post in this thread on how to capture the date on whcih a deal entered a stage, please refer to this blog post Sales automation: How to improve efficiency and meet your goals. While in the blog post, the date is created as a Contact property, I feel it make more sense to implement it as a Deal property instead of a Contact property.
Will post here if I can make this work.