Time Deal spent or is in a stage

Smart CRM & Sales Hub CRM
,
1

Hi!

I’m trying to create a calculated property that shows the time a deal is in a stage but with a different approach, the idea is:

A calculated property that will show the time a deal spent on a stage if the deal already left that stage OR if the deal is still in that stage, then it shows how long it has been there. Something like:

If Cumulative time in stage is known, use Cumulative time in stage

Else use Time entered on stage - Current Date

But unfortunately there isn’t a “Current Date” or “now()” function on Hubspot, so I searched and found that you can create a “Time since” type of calculated property which I did create, but when I try to use it on another calculated property, I can’t select it. Is it a Hubspot limitation?

After searching for quite some time, I ran out of ideas. Is my idea possible to execute? If so, please let me know.

Thanks!

2

Hi @LQuirinoFreit,

Are you aware of this property?

Time in current stage: the time the deal has spent in the current pipeline stage.

It’s a separate property but might achieve the same goal.

Best regards

3

Hi @karstenkoehler ,

I didn’t find it because I was looking for the name in english but it is translated to brazilian portuguese :sweat_smile:, this solves one part of my situation. The other is:

Siince Time in current stage is a calculated property, can I use it in another calculated property?

My idea is a calculated property with a formula like this:

if(

is_know(Cumulative time in Stage),

Cumulative time in “Desired stage”,

Time in current Stage

)

But when I try to select Time in current Stage, it isn’t available.

4

@LQuirinoFreit you’re right - some field types are not supported, unfortunately. If you’re not seeing it, it’s not available :confused:

5

@karstenkoehler :disappointed_face:

I understand, thanks for the support!