Confiform: Summing up values based on checkbox group choices

[Dan Behman]

Hello,

I have a confiform that has a checkbox group field with many different choices of task types. Each task type has a specific story point value (a number). I want to be able to calculate the total of all story points for the tasks that the user chooses (checks off in the checkbox group).

I've tried adding a Formula field named storyPointTotal with the following expression in it (simplified to just 3 for ease of illustration), note that task1, task2, task3 are the IDs and not the labels:

IF(NOTEMPTY("[entry.tasksForBuild:task1]"),5,0) + IF(NOTEMPTY("[entry.tasksForBuild:task2]"),6,0) + IF(NOTEMPTY("[entry.tasksForBuild:task3]"),5,0)

and then I display that field in my IFTTT macro that creates my JIRA epic, however I always get 0 regardless of what I choose in my checkbox group.

Any help would be greatly appreciated.

Thanks,
Dan

[Alex Medved _ConfiForms_ · Accepted solution]

Not sure I understand this completely but may be you need to do something like this

IF([entry.tasksForBuild.hasValue(task1)],5,0) + IF([entry.tasksForBuild.hasValue(task2)],5,0) + IF([entry.tasksForBuild.hasValue(task3)],5,0)

 (this assumes the tasksForBuild field has AT least one value selected)

[Dan Behman]

That works!!! As usual you're the best!!!!!