Number of days in status

[gustav.jacobsson (Gustav)]

Hello,

I need help in tracking number of days in a certain “Stage” or “Status”.

We use ca 5 different statuses such as "Initial contact, Opportunity, Proposal sent, etc. I would like track the number of days in each status. How can I do this?

Best
Gustav

[JCorrell (Jim - The Monday Man)]

@gustav.jacobsson

I think the simplest way to get started would be to use pairs of custom automations as show below for each status (and adding a timer for each one as well).

If you want the values to be show in days, you will also need a formula column for each. Something like this {Opportunity Timer#Hours}/24.

---

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: The ITEM ID column - What most people don’t know.
Contact me directly here: Contact – The Monday Man

[cberman (Corey)]

There are some marketplace apps that do what you’re asking for:

Retrospective Tools

Bottlenecks

[gustav.jacobsson (Gustav)]

Hi,

Thank you for quick response.

I was thinking more of something like this (This is what I have for days in Pipeline):

I would like to have a similar column which count days in stage x. If stage changes from X to Y the number of days resets. There is no need to see the number of days for each stage, just the latest stage
Is that possible?

Br
Gustav

[JCorrell (Jim - The Monday Man)]

@gustav.jacobsson

Yes…

formula:
DAYS(FORMAT_DATE(TODAY(),“YYYY-MM-DD”), {Stage Start Date})

automation:

[gustav.jacobsson (Gustav)]

Hi!

Thank you! That worked out well