# Calculated Property Creation Formula

**URL:** <https://community.hubspot.com/t/calculated-property-creation-formula/122944>\
**Category:** CRM\
**Tags:** professional\
**Created:** [December 23, 2024, 9:40am UTC](https://community.hubspot.com/t/calculated-property-creation-formula/122944 "2024-12-23T09:40:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mariselvi](https://avatars.discourse-cdn.com/v4/letter/m/b3f665/32.png) [@mariselvi](https://community.hubspot.com/u/mariselvi)\
**Post date:** [December 23, 2024, 9:40am UTC](https://community.hubspot.com/t/calculated-property-creation-formula/122944/1 "2024-12-23T09:40:35Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [December 23, 2024, 9:44am UTC](https://community.hubspot.com/t/calculated-property-creation-formula/122944/2 "2024-12-23T09:44:32Z")

</div>

Hi @mariselvi,

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

 ![karstenkoehler_0-1734946990198.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/9/b/9b41b3e9dff0d079afef797932a08ac0be3e207b.png)

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

---

<div class="post-metadata">

**Author:** ![mariselvi](https://avatars.discourse-cdn.com/v4/letter/m/b3f665/32.png) [@mariselvi](https://community.hubspot.com/u/mariselvi)\
**Post date:** [December 23, 2024, 9:49am UTC](https://community.hubspot.com/t/calculated-property-creation-formula/122944/3 "2024-12-23T09:49:49Z")

</div>

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