Calculate Value for custom field from other custom fields

Question

I have 4 single select list custom fields all with the same values which are alphanumeric:

* 0 (No impact)
* 1 (Negligible)
* 2 (Minor)
* 3 (Indirect)
* 4 (Moderate)
* 5 (Major)

I want to calculate a new numeric field from these values, I was hoping to do something like below but it is not working. I am not sure if the main problem is being the alphanumeric field values I am trying to pull as I can't even seem to pull one custom field value into my new field.

{{#=}}{{issue.customfield.asNumber}} + {{issue.customfield.asNumber}} +{{issue.customfield.asNumber}} +{{issue.customfield.asNumber}} + {{/}}

I am not interested in any add-on's just want to know if I can do this with smart values.

Najm Polaris · Accepted Answer

Hi @Dani Miles ,

the alphanumeric value might be the issue. Try with just number field and it should work.

Sum of smart values

{{#=}}{{issue.customfield1}}+{{issue.fcustomfield2}}+...{{/}}

Bill Sheboy · Accepted Answer

Hi @Dani Miles

As your single-select values contain a number and text, you could extract the number before the operations, such as using the left() function: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-text-fields/#left-int-length-

For example:

I added a default of 0 to the end of the expression.

Kind regards,
Bill