Automate Story points field to populate as SUM of two other fields in the Jira issue

[Andrews Rohit Dean]

Hi,

I am trying to achieve the following task in the Jira automation.

I have two custom fields (number type) in the Jira issue. I am trying to set up automation such that the field 'Story Points' should populate as the sum of these two custom fields.

Currently, my automation rule looks as follows and I'm stuck here:

Thank you in advance for helping me sort this out.

[Vikrant Yadav · Accepted solution]

Hi @Andrews Rohit Dean  Welcome to Atlassian Community!

Are you trying to update Story points on issue creation? OR want to update story point field when any change in number field value ?

In Edit Issue Field Action >> Select Story points field and Insert following value , kindly replace custom field id with your number field id . 

{{#=}}{{customField_10029}} + {{customField_10030}}{{/}}

Thanks

V.Y

[Andrews Rohit Dean]

Thanks, Vikrant, I want the story points field to update whenever there is any change in the custom number fields value.

Let me try your suggested solution. Thanks again.

Regards,

Andrews

[Vikrant Yadav]

Okay, @Andrews Rohit Dean In both cases same mathematical operations works. 

I hope this helps to answer your question. 

[Andrews Rohit Dean]

@Vikrant Yadav Thanks for the formula and it works fine, except when the value of any of my custom fields is 'none' (when the user has not provided any value). In such a case, the automation fails.

Can the formula somehow be updated to consider the value 'none' equivalent to zero?

Regards,

Andrews

[Vikrant Yadav]

Great! Glad to hear it works for you. 

For this, kindly apply condition before Action, When Field 2 is empty in that case it is failing. Apply condition like when Field2  . Like when it's empty set value to 0.

Thanks

[Vikrant Yadav]

Hi @Andrews Rohit Dean  PFA Attach solution with each steps :- 

Kindly mark solution as Accepted if it works for you, it helps other users who is looking for the same solution. 

[Bill Sheboy]

Hi @Andrews Rohit Dean 

Rather than using the conditional logic to test for empty fields, smart values allow you to specify a default value when they are empty.  For example, this will default the values to 0:

{{#=}}{{customField_10029|0}} + {{customField_10030|0}}{{/}}

Kind regards,
Bill