Time to Close

[TShemesh8]

Hi all,

I want to capture the time to close on deals but I don't want to count time in certain stages. This means I don't want to do a calculation of time between created and closed date. I tried to calculate by adding up the accumulative time in stages, but I think the problem is, since I have different pipelines, if I add up all the stages for all pipelines the field stays blank because there will never be a value for all properties. 

Any idea how I can create this without having to have a different property per pipeline? 

Thanks,

Tom

[Jnix284 · Accepted solution]

@TShemesh8 I agree with @PamCotton that calculated properties are the way to go, this post on LinkedIn has an easy example showing how to calculate time between two properties.

It comes down to whether you're timestamping your deals as they change stages if you'll have the properties available to calculate.

[PamCotton]

Hey @TShemesh8, thank you for posting in our Community!

Using a custom formula field, you can calculate the time to close deals without the need for separate properties per pipeline. However, the exact implementation may vary depending on your CRM system's features and customization options.

To our top experts @danmoyle @Jnix284 do you have any recommendations for @TShemesh8?

Thank you,

Pam

[Jnix284 · Accepted solution]

@TShemesh8 I agree with @PamCotton that calculated properties are the way to go, this post on LinkedIn has an easy example showing how to calculate time between two properties.

It comes down to whether you're timestamping your deals as they change stages if you'll have the properties available to calculate.

[TShemesh8]

Hi @Jnix284 , thanks for the reply.

How would I do this for multiple pipelines? would it be easier to create a custom property to calculate duration per stage and then create a calculation property that would add up the stages that are relevant for my time to close? 

[Jnix284 · Accepted solution]

Hi @TShemesh8 yes, you would need to create a custom property to calculate the duration between each stage - if your stages are different per pipeline, then you would need to repeat the process for both pipelines.

Once you have the individual stage calculated properties, you would create the sum property to toal them all together.