Calculated Property Creation Formula

Smart CRM & Sales Hub CRM
1

I have a Custom Property called “Cycle Time” , here I have to record the time between the deal created to the deal has attained “Contract Won/ Contract Lost” Deal Stage. What is the exact formula for this case. A single formula to record cycle time in a single Custom Property called “Cycle Time” for both contract won deals & contract lost deals.

I used “IF(Deal Stage = “Closed Won”, DATEDIFF(Close Date, Create Date, ‘days’),
IF(Deal Stage = “Closed Lost”, DATEDIFF(Lost Date, Create Date, ‘days’), NULL))”

& found formula error. Can anyone provide the exact formula for the above.

2

Hi @mariselvi,

Is there a reason that you’re not simply using a “time between” calculation method?

karstenkoehler_0-1734946990198.png
karstenkoehler_0-1734946990198.png1363×984 99.6 KB

Alternatively, there’s also this out-of-the-box deal property:

Days to close: the time between Create date and Close date. This can be used as a filter when building a custom single object report.

Best regards

3

Thanks, for your reply. This is helpful. Will try using your suggestions.