# Time in current deal stage **URL:** \ **Category:** Dashboards & Reporting\ **Created:** [September 20, 2017, 10:51am UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376 "2017-09-20T10:51:41Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Hana](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hana/32/30191_2.png) [@Hana](https://community.hubspot.com/u/Hana)\ **Post date:** [September 20, 2017, 10:51am UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/1 "2017-09-20T10:51:41Z")
Hi, is there a way how I can see in dashboard **current deal stages** and **current time in each stage.** I found out that “Time in stage xxx” shows values only for deals which finished, has been moved from this stage. This would help us to understand and identify deals they are in delays or simply to see that there can be a problem if the deal is not moving and already spend more than 5 days in current stage. ---
**Author:** ![edjusten](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/edjusten/32/14475_2.png) [@edjusten](https://community.hubspot.com/u/edjusten)\ **Post date:** [September 20, 2017, 9:19pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/2 "2017-09-20T21:19:01Z")
Hi @Hana Welcome to the Community! This thread [https://community.hubspot.com/t5/Sales-Dashboards-Reporting/Report-of-dates-and-times-spent-in-deal-stage/m-p/10704#M71](https://community.hubspot.com/t5/Sales-Dashboards-Reporting/Report-of-dates-and-times-spent-in-deal-stage/m-p/10704#M71) discusses the issues around creating an actvie _Time-in-deal-stage_ report in depth. Basically, the algorithm would have to be constantly recalculating the number of days in stage, which is technically not possible at this time. There is suggestion in the Ideas Forum located here: [https://community.hubspot.com/t5/HubSpot-Ideas/Dates-Spent-In-Deal-Stage/idi-p/11064](https://community.hubspot.com/t5/HubSpot-Ideas/Dates-Spent-In-Deal-Stage/idi-p/11064) Could you head over and add your feedback? Ed _INBOUND 2017 is just around the corner. Find out more at [inbound.com](http://inbound.com) or check out the post on the main Community page and check out the upcoming AMA with Deb Calvert._ ---
**Author:** ![rschaeffer](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rschaeffer/32/25270_2.png) [@rschaeffer](https://community.hubspot.com/u/rschaeffer)\ **Post date:** [May 16, 2019, 9:07pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/3 "2019-05-16T21:07:20Z")
I was looking to create a report that pulled the number of days between two time-based data points. For example, I was looking to find the number of days between “Date entered \*name of deal stage\*” and “Date Created” for a company. It was explained to me by Hubspot Support that this relied on heavy calculations that couldn’t be supported on the back end. I wish that the development team would work on solving for this as I think it would open up some valuable reporting insight. ---
**Author:** ![MikeLawson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mikelawson/32/41549_2.png) [@MikeLawson](https://community.hubspot.com/u/MikeLawson)\ **Post date:** [June 5, 2019, 9:07pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/4 "2019-06-05T21:07:05Z")
@rschaeffer Completely understand where you are coming from in the post! Being able to look at this at a business level, product level, and individual Sales Rep level can be extremely challenging inside of Hubspot Reporting. I have helped solve these problems in our [Sales Rep Scorecard application](https://www.rekener.com/sales-rep-scorecards-for-hubspot-crm). Let me know if you would like to chat further on this! ---
**Author:** ![CCS](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ccs/32/84335_2.png) [@CCS](https://community.hubspot.com/u/CCS)\ **Post date:** [October 14, 2019, 1:38am UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/5 "2019-10-14T01:38:17Z")
You can contact Pipedrive and find out how they did it. Their system calculates time in stage and shows it on each deal. ---
**Author:** ![lpodolsky](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lpodolsky/32/43030_2.png) [@lpodolsky](https://community.hubspot.com/u/lpodolsky)\ **Post date:** [August 13, 2020, 11:24pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/6 "2020-08-13T23:24:52Z")
Hi, Did you guys solve this? Seems like a basic piece of functionality to have. ---
**Author:** ![lpodolsky](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lpodolsky/32/43030_2.png) [@lpodolsky](https://community.hubspot.com/u/lpodolsky)\ **Post date:** [August 13, 2020, 11:42pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/7 "2020-08-13T23:42:08Z")
Hello, Did this get resolved? It would be helpful to run a simple view or report and show days in stage for every deal in the pipeline or the date the deal entered the stage. ---
**Author:** ![Dave94040](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dave94040/32/84335_2.png) [@Dave94040](https://community.hubspot.com/u/Dave94040)\ **Post date:** [August 19, 2020, 9:55pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/8 "2020-08-19T21:55:31Z")
Hi Ed, Back in 2017, you said Hubspot could not tell the sales team the time spent in various stages of the deal, to help monitor deal flow. It’s been three years. Any progress on that? Dave ---
**Author:** ![PamCotton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/pamcotton/32/47916_2.png) [@PamCotton](https://community.hubspot.com/u/PamCotton)\ **Post date:** [August 20, 2020, 3:25pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/9 "2020-08-20T15:25:46Z")
Hello @Dave94040 and @lpodolsky, Currently, you can create a “time between” property ( [more information here](https://knowledge.hubspot.com/crm-setup/create-calculation-properties) ), please note that this function is required a Pro/ Enterprise subscription. I will also share this ideas forum [here](https://community.hubspot.com/t5/HubSpot-Ideas/Calculate-and-Report-on-the-Time-between-Two-Properties/idi-p/36604), about this idea. I hope this information helps. Kindly, Pam ---
**Author:** ![HarvestROI](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/harvestroi/32/59980_2.png) [@HarvestROI](https://community.hubspot.com/u/HarvestROI)\ **Post date:** [August 24, 2020, 12:42pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/10 "2020-08-24T12:42:35Z")
You can create a “time between” but that doesn’t tell you how much time it is currently in the stage. For that, you would need to have a “today’s date” property and calculate the time between today and the date it entered the stage. Unfortunately, there is no way to automatically populate today’s date. ---
**Author:** ![Laureng47](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/laureng47/32/1529_2.png) [@Laureng47](https://community.hubspot.com/u/Laureng47)\ **Post date:** [September 17, 2020, 2:34pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/11 "2020-09-17T14:34:42Z")
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. I’d love an update as to where this sits on the roadmap. ---
**Author:** ![PamCotton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/pamcotton/32/47916_2.png) [@PamCotton](https://community.hubspot.com/u/PamCotton)\ **Post date:** [September 17, 2020, 6:01pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/12 "2020-09-17T18:01:35Z")
Hello @Laureng47 We have an ongoing thread that requests the ability to calculate “current time in stage” or “time until TODAY” [Here](https://community.hubspot.com/t5/HubSpot-Ideas/Time-in-Deal-Stage/idi-p/277082) I’d suggest if you could please give it an upvote and leave us your feedback on the link above it will help our product team to see what other users are in need. Thank you, Pam ---
**Author:** ![Laureng47](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/laureng47/32/1529_2.png) [@Laureng47](https://community.hubspot.com/u/Laureng47)\ **Post date:** [September 17, 2020, 6:59pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/13 "2020-09-17T18:59:18Z")
Thanks Pam! I will do that now 🙂 ---
**Author:** ![aviggiano](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/aviggiano/32/84489_2.png) [@aviggiano](https://community.hubspot.com/u/aviggiano)\ **Post date:** [December 2, 2020, 2:21am UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/14 "2020-12-02T02:21:17Z")
Hello I managed to calculate “Today’s Date” using the following Workflow: ![34896iCC5B3EB61928CE8F.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/9/e/9ec39e2e7d6b5878172cabe143da7529f7e95234.png) ---
**Author:** ![bfricke](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/bfricke/32/32521_2.png) [@bfricke](https://community.hubspot.com/u/bfricke)\ **Post date:** [December 2, 2020, 8:25pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/15 "2020-12-02T20:25:28Z")
Have you done anything past this step? I tried to then create a calculated property but I couldn’t not do so using this new field. ---
**Author:** ![aviggiano](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/aviggiano/32/84489_2.png) [@aviggiano](https://community.hubspot.com/u/aviggiano)\ **Post date:** [December 2, 2020, 8:40pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/16 "2020-12-02T20:40:51Z")
Yes, I followed [this step on this other thread](https://community.hubspot.com/t5/HubSpot-Ideas/Time-in-Deal-Stage/idc-p/384374/highlight/true#M67949) to create a “calculated field” that subtract two dates. ---
**Author:** ![RWollerich](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rwollerich/32/38114_2.png) [@RWollerich](https://community.hubspot.com/u/RWollerich)\ **Post date:** [March 29, 2022, 7:40pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/17 "2022-03-29T19:40:13Z")
This seems to be heading into the right direction. I’ve set up the following to calculate time in **current** deal stage: 1. for each deal stage you create a property called ‘time in X deal stage’. 2. you create a workflow that says: if deal is in stage X, copy value of ‘time in X deal stage’ into ‘time in current deal stage’. In the workflow, you set this up for each deal stage and voila! ---
**Author:** ![DStaat](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dstaat/32/3537_2.png) [@DStaat](https://community.hubspot.com/u/DStaat)\ **Post date:** [August 9, 2023, 8:23pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/18 "2023-08-09T20:23:07Z")
Hey @Hana, There’s an app called Timerman that would help with this! It tracks the times by stage on your deals and tickets and records them for you. ![DStaat_0-1691612508918.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/2/6/26e15da217e30ad7b19766d241b1668eaca9f48c.png) You can check out the app on the HubSpot Marketplace [here](https://ecosystem.hubspot.com/marketplace/apps/customer-service/help-desk/timerman-by-a8labs-510130). I’d also be happy to hop on a call with you and help you get set up! Best, -David Staat ---
**Author:** ![vanessahunt](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/vanessahunt/32/38885_2.png) [@vanessahunt](https://community.hubspot.com/u/vanessahunt)\ **Post date:** [August 24, 2023, 7:37pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/19 "2023-08-24T19:37:35Z")
This seems to be a valid requirement for most businesses. This was requested in 2017 - it’s a few years down the line, so would love to know if there is an update on this. We would easily like to see: How long has a Deal been in each Stage? Pleeease can this be prioritised, HubSpot. Thank you 🙏🏻 ---
**Author:** ![Berangere](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/berangere/32/220784_2.png) [@Berangere](https://community.hubspot.com/u/Berangere)\ **Post date:** [August 25, 2023, 1:29pm UTC](https://community.hubspot.com/t/time-in-current-deal-stage/3376/20 "2023-08-25T13:29:45Z")
Hi @vanessahunt, Thank you for reaching out to the Community! I found for you the solution from @karstenkoehler on this post “[Create “time in deal stage” report](https://community.hubspot.com/t5/Dashboards-Reporting/Create-quot-time-in-deal-stage-quot-report/m-p/401189)” that explains how to do this 🙂 Have a great day! Best, Bérangère [Next page](https://community.hubspot.com/t/time-in-current-deal-stage/3376.md?page=2)