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

Hi Team, Want to add values of two custom fields and based on the sum, want to put some conditions

Sabyasachi Samal_it7sy0

Example:

There are two custom fields as "Dev Estimation" and "QA Estimation". I want to sum this with conditions like if the sum is greater than equals to 1 and less than equals to 3, then need to update the Story points field as 1.

Tried this with below logics using smart value but getting error. Please let me know how to achieve the same. PS: do not want to create one custom field to store the summed value. I am using JIRA cloud.

{{#if(and(((issue.Dev Estimation) + (issue.QA Estimation)).gte(1),((issue.Dev Estimation) + (issue.QA Estimation)).lte(3)))}}(issue.Story Points = 1) {{/}}

Accepted answers

Yong Yang

Hi @Sabyasachi Samal

Welcome to our Community.

Please try to use a {Create variable} action to store the sum of dev & QA estimations:

{{#=}}{{issue.Dev Estimation|0}} + {{issue.QA Estimation|0}}{{/}}

Then use if-else condition to edit the value of Story points.

Hope it helps & Thanks,

YY哥, Atlassian Certified Expert

Cloze Tech, China

All comments

Yong Yang

Hi @Sabyasachi Samal

Welcome to our Community.

Please try to use a {Create variable} action to store the sum of dev & QA estimations:

{{#=}}{{issue.Dev Estimation|0}} + {{issue.QA Estimation|0}}{{/}}

Then use if-else condition to edit the value of Story points.

Hope it helps & Thanks,

YY哥, Atlassian Certified Expert

Cloze Tech, China

Bill Sheboy

Hi @Sabyasachi Samal

To assist with automation rule questions, context is needed. Please post the following to help the community offer suggestions:

an image of your complete automation rule,
images of any relevant actions / conditions / branches,
an image of the audit log details showing the rule execution with any errors, and
explain what is not working as expected.

Thanks!

Kind regards,
Bill

Sabyasachi Samal_it7sy0

Hi @Yong Yang Thank you for the response. The Create variable is working fine. But not able to update the Story points. I want below logic to work and if you can help me. Also please find the rules I am using, Please let me know if this is the correct way.

Story point.png

Sabyasachi Samal_it7sy0

Hi @Bill Sheboy Thanks for your response. Please find the rule details I am using. It is executed successfully but the Story Points field is not updating properly. Story point.png

Sabyasachi Samal_it7sy0

Hi @Yong Yang Tried using below way also, it only executes first if condition. Story point2.png

Yong Yang

Hi @Sabyasachi Samal

It seems the condition is not correct. Please use this condition:

Thanks,

YY哥

Bill Sheboy

Thanks for that information.

The "more options" and "additional fields" sections of the Edit Issue Action use JSON, as described here: https://support.atlassian.com/cloud-automation/docs/advanced-field-editing-using-json/

However you should not need those for your scenario, as the field could be selected from the dropdown list and then set using a smart value expression.

Your expressions are incorrect for setting the field. Please review the documentation for conditional logic: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-conditional-logic/

Also, Created Variables are text, and so must be converted to number values with asNumber to be used as you show: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-text-fields/#asNumber

Sabyasachi Samal_it7sy0

@Bill Sheboy I tried with all the reference you shared. Still it is not working as expected. Story point4.png Story point3.png

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-cloud