nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Add up values from different fields with multiple selection

Daniel Pfeffer

Hello Community

I am trying to create an automation to calculate the sum of different fields (see below) that have a multiple selection with a scale of 0 - 3. The scale is structured as follows in each field:

0 - No
1 - Partially
2 - Yes

Objective: The sum of the selected scales is calculated in a field, i.e. only the 1st digit of the scale is taken into account.

Question: Is such automation even possible and if so, how?

I would be very happy if someone from the community could help me.

Kind regards

Daniel

Accepted answers

Bill Sheboy

Hi @Daniel Pfeffer

For the multiple-select option field you show, the values have a digit in the first character. That could be extracted using the left() function. And then the list of values could be joined together for including in a math expression.

For example:

{{#=}} 0{{issue.myCustomField.value.left(1).join(" + ")}} {{/}}

I added a default value of zero at the front in case no values are selected. As one of your values is "0 - Nein" you may want to change that.

Kind regards,
Bill

All comments

Bill Sheboy

Hi @Daniel Pfeffer

For example:

{{#=}} 0{{issue.myCustomField.value.left(1).join(" + ")}} {{/}}

I added a default value of zero at the front in case no values are selected. As one of your values is "0 - Nein" you may want to change that.

Kind regards,
Bill

Daniel Pfeffer

Hi @Bill Sheboy

Many thanks for the tip. Unfortunately, I can't get this automation to work as I'm still new to Jira.

Can you also give me a tip on how to set up the automation workflow for this case? I have searched the forum, but unfortunately I have not found a comparable case.

It would help me a lot.
Best regards
Daniel

Bill Sheboy

After substituting in your field's smart value (or custom field ID) in the expression I provided, you may copy-and-paste that directly into the field as the sum. To confirm the smart value (or custom field ID) for your field, please use this how-to article: https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/

The rule you show is branching to the parent. Are you trying to sum the fields from the trigger issue, the children of the parent, or something else?

Daniel Pfeffer

Hi @Bill Sheboy

Thanks to your help, I have now been able to set up the automation. Thank you very much for your support.

Here is the solution to the problem:

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-service-management-cloud

sum

sumup

jira-service-management