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; } } }

Need help to multiply value of 2 custom fields in Automation Smart Values for Team Managed Project

gowri.kumar

Hi,

I have a Team managed project in JIRA. It has 2 list type custom fields - Impact and Probability, which have numbers in the dropdown.

I would like to multiply the selected value of the 2 custom fields and save them in another field (Score)

Score = Impact * Probabilty

However, I am unable to make this work using Automation and Smart Values. Please help! Thank you in Advance.

Accepted answers

Gaurav_0av1h6

Hello @gowri.kumar

There are a couple of alternate options to achieve this, apart from the option suggested by @Pramodh M

1. If the values for Impact and Probability are pre-defined; then you can create an If-Else construct in the Automation and define the value of Score, as you would know the options beforehand.

2. If the values es for Impact and Probability are not pre-defined; then you can create automation as per the below screenshot.

Please share in case you need further support.

NOTE: Impact is a common field that can cause an issue. To avoid that, I have used Impact1 as temporary workaround.

Automate Multiply 1.PNG Automate Multiply 2.PNG

All comments

Pramodh M

Hi @gowri.kumar

Welcome to the Community!!

Trigger - Field Value Chaged (Probabilty, Impact )

Edit - Field value (Score)

{{#=}}{{issue.Probabilty}} * {{issue.Impact }}{{/}}

Reference here

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/

https://support.atlassian.com/cloud-automation/docs/examples-of-using-math-expression-smart-values/

Thanks,
Pramodh

Gaurav_0av1h6

Hello @gowri.kumar

There are a couple of alternate options to achieve this, apart from the option suggested by @Pramodh M

1. If the values for Impact and Probability are pre-defined; then you can create an If-Else construct in the Automation and define the value of Score, as you would know the options beforehand.

2. If the values es for Impact and Probability are not pre-defined; then you can create automation as per the below screenshot.

Please share in case you need further support.

NOTE: Impact is a common field that can cause an issue. To avoid that, I have used Impact1 as temporary workaround.

Automate Multiply 1.PNG Automate Multiply 2.PNG

gowri.kumar

Unfortunately I already tried that and received the following error in Audit log:

Error rendering smart-values when executing this rule:

Unknown unary operator * at character position 1: *

gowri.kumar

Hi @Gaurav

In this case it just returns empty value, even though the audit log shows success

Screenshot 2022-02-09 at 5.46.34 PM.png

Result:

Screenshot 2022-02-09 at 5.47.46 PM.png

Gaurav_0av1h6

Hello @gowri.kumar

Kindly share the screenshot of the automation rule. I have tested the rule which I shared and it worked fine.

gowri.kumar

Thanks @Gaurav.

Please find the screenshot of the rule below. Also, do note that the fields belong to a Team managed project and they are List type custom fields.

Screenshot 2022-02-09 at 6.04.37 PM.png

gowri.kumar

Hi @Pramodh M

I think the above formula you have mentioned would also work as long as the field name is not 'Impact'. The issue seems to exist with the custom field name (Impact) and not the formula itself.

Welcome!

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

Quick Links

Find more posts tagged with

custom-field

cloud

jira-software

jira-software-cloud

automation

smart-value