Need assistance with Jira Cloud Automation

RNV Jira1

Hi All,

I am new to Jira automation and i have the requirement of to complete the following -
We 4 Numeric value custom fields in Jira cloud and i need help with creating an automation rule to get the highest value of the first 3 fields to be populated on the 4th field.

Example:
Field 1 - Drop down values 1,2,3,4,5 
Selected value - 4

Field 2 - Drop down values 1,2,3,4,5 
Selected value - 1

Field 3 - Drop down values 1,2,3,4,5 
Selected value - 5

Field 4 - Drop down values 1,2,3,4,5 
Need the value of "Field 3"  which is 5, as that is the highest value from the above 3 fields

Any guidance here will be very helpful, thank you in advance

Alex Koxaras -Relational-

Hi @RNV Jira1 and welcome to the community!

Try the following, it worked for me:

• Create a rule
• Add as trigger "Field Value Change" and select all numeric fields you want to this rule to get triggered
• Create a variable with a name "maxValue" and enter

  {{#=}}max({{issue.fields.NumSel1}},{{issue.fields.NumSel2}},{{issue.fields.NumSel3}}){{/}}

• Add a new action to edit the last single select field you want
• Add the {{maxValue}} variable you created

 

Cheers,
Alex