I am looking for a formula that will help me set and determine priorities for product features we are going to release. I am struggling with the formula or the ability to get the sum of all items selected for a single multi-select field.
Example below:
Category 1
- Item A = 1
- Item B = 3
- Item c = 4
Category 2
- Item A = 1
- Item B = 3
- Item c = 4
From Category 1, I select Item A and Item B and in Category 2 I select Item B.
I want to be able to add Category 1’s total selected value to Category 2’s total selected value.
Sum(Category 1(1+3)), (Category 2 (3)) - I know this is not correct but this is the general concept.