Really need a report that shows a list of Deals in the Pipeline and how long each individual deal has spent in it's current stage. I can't believe other users aren't clamoring for this... very inportant!!
Same here, so important! We need to be able to build reports off of this in order to make sure reps don't let any deal sit in a given stage for too long (eg. report of all the deals currently in stage X that have been in stage X for more than X days).
Same! This is such a critical metric for ensuring deals are moving at the right pace and to unstick deals that are stuck in a stage. I'd like to add a +1 to desperately needing the "today's date" property to do my job as a sales leader properly with hubspot as our CRM. There are a variety of other reports I that I can't produce in Hubspot as well because of this missing piece.
This is genuinely a critical function if you are going to compete with other CRMs. How can a sales team set and keep SLAs if they can only look at the time spent in stage retroactively? Please fix it or bring in a "Today's Date" field so people can work around it using a calculated property and some basic automation i.e.
Enters deal stage > set date picker to "date of entry"
Calc field = time between "Date of entry" & "Today's Date"
Report = all deals with "Calc field" >7
Automation = id "calc field">7 notify salesperson and manager.
This is a huge hole in the system and is going to cost your partners deals.
I ended up creating a workflow that triggers each midnight (again using very complicated logic - as it is not possible to do it in Hubspot directly) and that sets a date picker variable with the value -- Day of Step. That is how I have simulated the "Todays Date" variable.
@RDAMA I didn't see your original reply otherwise I would have reached out! Would you be able to share your workflow logic? It would be greatly appreciated!