Calculated Property to Count # of Values in Another Property

[AlaynaNelson]

We have a property called "All Claimants" that is a multi-checkbox property. Sometimes 1 can get selected, sometimes 20 can be selected. We tried creating a calculated property to count the number of values that are in the "All Claimants" property and named it "Count of All Claimants". We set it up as a count property (see screenshot) but it doesn't appear to work as it should. We created it as a ticket property and basically we want it to count the number of values in "All Claimants" and tell us that in number format. So if we have 3 different options selected in "All Claimants" we'd want the "Count of All Claimants" property to say "3" but right now it says 0 no matter what. 

It would be great if calculated properties could look at other ticket properties and count values within the properties. 

[markusarvidsson]

Hi, I would like the same functiobnality.  My use case is to count the number of checked options in a multiple checkbox property. I would like to create a calculated property to count the number of checked option. The output should be the number of checked otions.

[amsteiner]

+1! I would also like to sum the number of checked options. e.g. if a Deal is referring to a number of registered weeks, I want to have a property that also sums the amount of weeks so that reporting is easier. 

[MBarton00]

Hello! We also need this functionality. We need the ability to say if values A-G are the options and someone selects A, B, D, F - for example, another property would tally that to 4 total selections. Then, accurately update when values are added or taken away. With workflows today, this can be achieved, but it works best if the value pool is small and can easily misfire. If you have more than 5 values, the workflow quickly becomes unwieldy and hard to manage. 

[NHiltenkamp]

Hi! Absolutely needed.  I have more than 50 values that need to be counted, while new values can be created at any time. So, the "count" workflow we find here is absolutely not feasible.

[limeduck]

If anybody is still looking for this, I have found a workflow method that can handle any number of property values using a custom code action. Because HubSpot expresses a multi-checkbox as a series of values separated by semicolons, we can get the number of values by counting the semicolons and adding one. In python that's 

CountOfValues = MultiPickProperty.count(';') +1

All you need is a workflow that fires whenever your multi-picklist property changes (and is known, if it's empty, it'll throw an error) and calls the code. Then you have your count as a variable inside the workflow, and you can use an Edit Record action to assign it to a property on the triggeringn record. Remember to allow reenrollment.

[Melly2022]

+++++ have needed this several times this month and had to reject leadership report requests. 

[Melly2022]

+++ have needed this functionality across several objects over the last month and have had to reject a lot of leadership report requests due to the limitations