# Doing math in workflows

**URL:** <https://community.hubspot.com/t/doing-math-in-workflows/16940>\
**Category:** HubSpot Ideas\
**Tags:** workflows\
**Created:** [October 28, 2019, 11:12pm UTC](https://community.hubspot.com/t/doing-math-in-workflows/16940 "2019-10-28T23:12:07Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![brhellman](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/brhellman/32/2490_2.png) [@brhellman](https://community.hubspot.com/u/brhellman)\
**Post date:** [October 28, 2019, 11:12pm UTC](https://community.hubspot.com/t/doing-math-in-workflows/16940/1 "2019-10-28T23:12:07Z")

</div>

It would be helpful if in your workflows you could do math. For example we have a workflow that creates a new deal in the renewal pipeline for every contract that is invoiced. For most of the contracts simply adding a due date of 365 days (1 year contract length) is good enough. However, some of our customers have a 3-5 year length which we have defined in a custom “Contract Length”. Ideally you would be able to have a workflow that could do something like $Close\_Date + $Contract Length = $Due\_Date.

I could see other uses for this as well, but this is the immediate one that comes to mind.

---

<div class="post-metadata">

**Author:** ![rensdckw](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rensdckw/32/31184_2.png) [@rensdckw](https://community.hubspot.com/u/rensdckw)\
**Post date:** [March 12, 2020, 8:28am UTC](https://community.hubspot.com/t/doing-math-in-workflows/16940/2 "2020-03-12T08:28:19Z")

</div>

Hi,

I don’t know whether this problem has already been solved for you, but HubSpot offers calculation properties:

> **[Create calculation and rollup properties](https://knowledge.hubspot.com/properties/create-calculation-properties)**
>
> Learn how you can create calculation, time since, time between, time until, or rollup properties in HubSpot based on property values.

Maybe this can help.

---

<div class="post-metadata">

**Author:** ![jmbray](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jmbray/32/23574_2.png) [@jmbray](https://community.hubspot.com/u/jmbray)\
**Post date:** [March 29, 2021, 9:27pm UTC](https://community.hubspot.com/t/doing-math-in-workflows/16940/3 "2021-03-29T21:27:48Z")

</div>

This would be very helpful for us to help calculate some deal properties. The HubSpot calculation properties work well, but there is just a limit to how many you can use. I believe we have 5 on the sales pro plan which is not sufficient for our needs and it’s cost-prohibitive for us to move up to Enterprise where there are 200 (I believe) (Quite a big range jump). I can understand if ‘always on’ calculation properties might be expensive, which is why adding simple multiplication and division would be sufficient and take care of our needs. Here’s 1 example we’d like to use, we’d like the ability to show each individual sales reps’ bonus on their individual KPI dashboards which is a calculation of a % of the sale with some variability. That could eat up quite a few calculation properties with just 2 reps. Hope this gets considered in the future!

---

<div class="post-metadata">

**Author:** ![ksalazar](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ksalazar/32/38459_2.png) [@ksalazar](https://community.hubspot.com/u/ksalazar)\
**Post date:** [August 19, 2021, 4:23pm UTC](https://community.hubspot.com/t/doing-math-in-workflows/16940/4 "2021-08-19T16:23:49Z")

</div>

we would like to see the ability to add a couple currency fields that automatically add up and udpate the deal amount.

---

<div class="post-metadata">

**Author:** ![GEiselt](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/geiselt/32/89529_2.png) [@GEiselt](https://community.hubspot.com/u/GEiselt)\
**Post date:** [February 28, 2022, 8:13pm UTC](https://community.hubspot.com/t/doing-math-in-workflows/16940/5 "2022-02-28T20:13:39Z")

</div>

This would be incredibly helpful for us. We manage project costs on custom object records that occasionally require manual adjustments by our team. Calculation properties are clunky to use (having to use another property to offset the charge). The ideal solution would be being able to run a workflow when the record is set to a specific stage (e.g. ready to review) which adds/multiplies a few number fields. The team member could then take a look and adjust or approve if need be.

---

<div class="post-metadata">

**Author:** ![JoelWhitford](https://avatars.discourse-cdn.com/v4/letter/j/977dab/32.png) [@JoelWhitford](https://community.hubspot.com/u/JoelWhitford)\
**Post date:** [March 3, 2023, 10:10am UTC](https://community.hubspot.com/t/doing-math-in-workflows/16940/6 "2023-03-03T10:10:17Z")

</div>

Personally I think that the criteria behind this needs to be stripped back - and the ‘essence’ of what is required here is merely just the option of being able to do mathematical equations in workflows.  
If 2 x number properties exist (or more) in the CRM, allow functionality that adds them together, divide, multiply, etc. If numerous number properties exist, do the same (ie. provide the functionality).  
For accounts that are pro that have score or calculation property limits in place (ie. 5 only), then having this functionality in workflows would provide more flexibility, particularly for those accounts that can’t equitably justify moving to enterprise level subscriptions.  
How amazing would it be, within workflows, to have the option to set: If property A is known and proeprty B is known, set proeprty value C to: Property A + Property B.

---

<div class="post-metadata">

**Author:** ![CVedock](https://avatars.discourse-cdn.com/v4/letter/c/df788c/32.png) [@CVedock](https://community.hubspot.com/u/CVedock)\
**Post date:** [July 14, 2023, 3:55pm UTC](https://community.hubspot.com/t/doing-math-in-workflows/16940/7 "2023-07-14T15:55:40Z")

</div>

Yes - need this functionality. I want to create a calculation, but calculation fields only allow me to use ONE condition. I want to forecast our recurring client revenue, so if renewal date = this month or if close date = this month for a specific pipeline, then calculate and give me that number. Not to mention, WHY do date fields not allow dates like salesforce to select “THIS MONTH” “THIS YEAR”, etc. I am setting reminders for myself to manually update workflows each month.

---

<div class="post-metadata">

**Author:** ![ALeong](https://avatars.discourse-cdn.com/v4/letter/a/4af34b/32.png) [@ALeong](https://community.hubspot.com/u/ALeong)\
**Post date:** [August 30, 2023, 4:14pm UTC](https://community.hubspot.com/t/doing-math-in-workflows/16940/8 "2023-08-30T16:14:24Z")

</div>

This would be extremely helpful. I can create calculation properties, however, I would like amount to be calculated based on additional property fields I have created. With amount being a HubSpot created field, I’m not able to turn it into a calculation property.

---

<div class="post-metadata">

**Author:** ![casaselpilar](https://avatars.discourse-cdn.com/v4/letter/c/8dc957/32.png) [@casaselpilar](https://community.hubspot.com/u/casaselpilar)\
**Post date:** [March 3, 2024, 9:11pm UTC](https://community.hubspot.com/t/doing-math-in-workflows/16940/9 "2024-03-03T21:11:59Z")

</div>

Totalmente es una grosería solo tener 5 cálculos en la versión Pro, con lo que se paga… Ojalá la CEO de HubSpot con esta visión de los clientes al centro hagan caso.

---

<div class="post-metadata">

**Author:** ![Thrive](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/thrive/32/19516_2.png) [@Thrive](https://community.hubspot.com/u/Thrive)\
**Post date:** [July 24, 2024, 12:22am UTC](https://community.hubspot.com/t/doing-math-in-workflows/16940/10 "2024-07-24T00:22:13Z")

</div>

Hi all, we have build an app that allows you to build an **infinite** number of calculations, using workflows. Feel free to check it out here: [HubSpot Marketplace](https://ecosystem.hubspot.com/marketplace/apps/marketing/data-management/calculations-3449553)

---

<div class="post-metadata">

**Author:** ![Thrive](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/thrive/32/19516_2.png) [@Thrive](https://community.hubspot.com/u/Thrive)\
**Post date:** [July 24, 2024, 12:24am UTC](https://community.hubspot.com/t/doing-math-in-workflows/16940/11 "2024-07-24T00:24:42Z")

</div>

Hi all, we have created an app that allows you to build an **infinite number** of calculations, using workflows. Feel free to check it out here: [HubSpot Marketplace](https://ecosystem.hubspot.com/marketplace/apps/marketing/data-management/calculations-3449553)

---

<div class="post-metadata">

**Author:** ![davidlaloum](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/davidlaloum/32/14727_2.png) [@davidlaloum](https://community.hubspot.com/u/davidlaloum)\
**Post date:** [December 12, 2024, 11:38am UTC](https://community.hubspot.com/t/doing-math-in-workflows/16940/12 "2024-12-12T11:38:46Z")

</div>

Hey, I tried to install your app but the instal is failling

 ![davidlaloum_0-1734003485255.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/a/ba855de33b969eac508e3ed364f4fbf8a42e0b7b.png)

---

<div class="post-metadata">

**Author:** ![Thrive](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/thrive/32/19516_2.png) [@Thrive](https://community.hubspot.com/u/Thrive)\
**Post date:** [December 13, 2024, 4:20am UTC](https://community.hubspot.com/t/doing-math-in-workflows/16940/13 "2024-12-13T04:20:17Z")

</div>

Hi, can you try using this link instead:  
[https://app.hubspot.com/oauth/authorize?client\_id=853049de-ff10-4c28-8e62-03be560e5028&redirect\_uri=https://thdigital.au/hs\_apps/calculations/live/oauth-callback/index.php&scope=crm.schemas.deals.read%20automation%20oauth%20crm.schemas.custom.read%20crm.objects.custom.read%20crm.objects.companies.read%20crm.objects.deals.read%20crm.schemas.contacts.read%20crm.objects.contacts.read%20crm.schemas.companies.read&optional\_scope=crm.schemas.companies.write%20crm.schemas.contacts.write%20crm.objects.contacts.write%20crm.schemas.deals.write%20crm.objects.custom.write%20crm.objects.companies.write%20crm.objects.deals.write](https://app.hubspot.com/oauth/authorize?client_id=853049de-ff10-4c28-8e62-03be560e5028&redirect_uri=https://thdigital.au/hs_apps/calculations/live/oauth-callback/index.php&scope=crm.schemas.deals.read%20automation%20oauth%20crm.schemas.custom.read%20crm.objects.custom.read%20crm.objects.companies.read%20crm.objects.deals.read%20crm.schemas.contacts.read%20crm.objects.contacts.read%20crm.schemas.companies.read&optional_scope=crm.schemas.companies.write%20crm.schemas.contacts.write%20crm.objects.contacts.write%20crm.schemas.deals.write%20crm.objects.custom.write%20crm.objects.companies.write%20crm.objects.deals.write)
