# Use Checkbox values for calculations **URL:** \ **Category:** CRM\ **Tags:** crm, enterprise\ **Created:** [February 15, 2021, 3:59pm UTC](https://community.hubspot.com/t/use-checkbox-values-for-calculations/31803 "2021-02-15T15:59:56Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![RLV2525](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rlv2525/32/97609_2.png) [@RLV2525](https://community.hubspot.com/u/RLV2525)\ **Post date:** [February 15, 2021, 3:59pm UTC](https://community.hubspot.com/t/use-checkbox-values-for-calculations/31803/1 "2021-02-15T15:59:56Z")
Hi everyone, I have made some properties that I would like to include in mails and surveys for customers to rate certain features. However, I would prefer to have some questions made into multiple checkboxes that are linked with other calculations that would in the end should reveal a total score. Therefore, my question is; is it possible to give checkboxes internal values that the calculation automatically pickup to generate a total score? Hope you guys can help. Thanks! Richard ---
**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:** [February 15, 2021, 4:15pm UTC](https://community.hubspot.com/t/use-checkbox-values-for-calculations/31803/2 "2021-02-15T16:15:14Z")
Hi @RLV2525, You’d have to “translate” the checkbox value into a number for HubSpot first. This would be possible with workflows and additional properties. For each checkbox, you’d create a custom property, e.g. _Form checkbox 1 (number)_. In a workflow, you would then enroll all contacts in your CRM (for example by selecting _Create date_ is known). The enrollment is followed by an if/then branch. If the checkbox value is known, set the _Form checkbox 1 (number)_ to [number]. If the checkbox value is unkown, set it to 0. It’s crucial that every contact gets a number, even if it’s a 0, otherwise the calculated property won’t… calculate. There needs to be a value in this field. (see [here](https://knowledge.hubspot.com/crm-setup/create-calculation-properties)) For the enrollment triggers, you might want to include a second option: _Create date_ is known OR Contact has filled out any form on any page You can use this form criterion for re-enrollment; for contacts who fill out the form and do not tick the box, but come back and tick the box the second time around. Unfortunately you need to create this for each checkbox. Hope this helps! ---
**Author:** ![EbarakHossain](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ebarakhossain/32/18191_2.png) [@EbarakHossain](https://community.hubspot.com/u/EbarakHossain)\ **Post date:** [October 7, 2021, 8:23am UTC](https://community.hubspot.com/t/use-checkbox-values-for-calculations/31803/3 "2021-10-07T08:23:00Z")
@karstenkoehler Good Morning Boss, I have [a similar issue](https://community.hubspot.com/t5/APIs-Integrations/Mapping-Checkbox-to-HubSpot-through-Zapier/m-p/506873/highlight/true#M47489) and would like to request you to kindly help me out. You’re my SuperHero in HubSpot category. Love you a lot! /Ebarak [HubSpot Community - Mapping Checkbox to HubSpot through Zapier. - HubSpot Community](https://community.hubspot.com/t5/APIs-Integrations/Mapping-Checkbox-to-HubSpot-through-Zapier/m-p/506873/highlight/true#M47489) ---
**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:** [October 7, 2021, 8:36am UTC](https://community.hubspot.com/t/use-checkbox-values-for-calculations/31803/4 "2021-10-07T08:36:29Z")
Hi @EbarakHossain, would love to help but not super-familiar with this setup of Tripetto/Zapier, unfortunately. Best regards! ---
**Author:** ![TheJamesWhaley](https://avatars.discourse-cdn.com/v4/letter/t/94ad74/32.png) [@TheJamesWhaley](https://community.hubspot.com/u/TheJamesWhaley)\ **Post date:** [October 11, 2024, 4:14pm UTC](https://community.hubspot.com/t/use-checkbox-values-for-calculations/31803/5 "2024-10-11T16:14:33Z")
I was able to achieve this without a workflow utilizing “Contains” inside of if statemetns in a calculated field. (((((if(contains([properties.focus\_area], “New Customers”), 25) + if(contains([properties.focus\_area], “Existing”), 20)) + if(contains([properties.focus\_area], “Solving a”), 15)) + if(contains([properties.focus\_area], “New Feature”), 15)) + if(contains([properties.focus\_area], “Update”), 15)) + if(contains([properties.focus\_area], “New Market”), 10)) ---
**Author:** ![TheJamesWhaley](https://avatars.discourse-cdn.com/v4/letter/t/94ad74/32.png) [@TheJamesWhaley](https://community.hubspot.com/u/TheJamesWhaley)\ **Post date:** [October 16, 2024, 5:03pm UTC](https://community.hubspot.com/t/use-checkbox-values-for-calculations/31803/6 "2024-10-16T17:03:14Z")
**I must add that this will not work correctly** unless you add a zero if condition is not met: (if(contains([properties.focus\_area], “New Customers”), 25,0)