Need to sum the values of 2 custom fields and enter them in the Original Estimate field

Oksana Baier January 30, 2023

I need to sum the values of 2 custom fields and enter them in the Original Estimate field
Original Estimate is a native field, I dont know type of this field
1) Can I use numeratic custom fields (Dev Estimate & QA Estimate) for sum values to Original Estimate?
2) What can I use for sum of custom fields?

 

I found an example https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/#Plus-Minus for story points only:
{{issue.Story Points.plus(issue.subtasks.size)}}

But dont understand how I can use it for custom fields... For example...
{{issue.Original Estimate.plus(???)}}

Help me, please)

4 answers

1 accepted

2 votes
Answer accepted
Oksana Baier January 30, 2023

Thank you
jFYI

1) Can I use numeratic custom fields (Dev Estimate & QA Estimate) for sum values to Original Estimate?

Yes, we can

2) What can I use for sum of custom fields?

Operation: {{#=}}{{customfield_10175}} + {{customfield_10174}}{{/}}
where customfield_10175, customfield_10174 - your custom field

0 votes
c-SChidambaram
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 11, 2023

hi, I'm trying a similar workflow and i'm not able to get the filed updated .

Steps:

1. I have two numeric fields for Dev and QA hrs.

2. Then doing below condition to edit original estimate field.

Results:

I see automation rule is successful but Original estimate is still 0.

Untitled.png

{{#=}}{{issue.[Custom Field].cf[10213].plus(issue.[Custom Field].cf[10212])}}{{/}}

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 30, 2023

An important thing to consider if you use @Clark Everson 's answer (which is completely right, do it as they said) is that the estimate fields tend to contain large numbers.  Date/time fields are milliseconds since 1/1/1970 (epoch dates), but I can't remember if the estimates are done in milliseconds or seconds. 

I doubt your Dev and QA estimates are being done in the same unit, so your automation will need to convert to seconds or milliseconds.  (e.g. if they are hours, you will need to multiply them by 3600, or 3,600,000 before putting it into the original estimate)

0 votes
Clark Everson
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 30, 2023

Hi Oksana,

You would want to look at some other smart value documentation. Original Estimate I am unsure on the type of field it is in Cloud but there are a lot of documentation on Smart Values[1]

Custom fields of almost all types have their own pages. But the link I attached is a link to all the types so should help!

[1] https://support.atlassian.com/cloud-automation/docs/smart-values-in-jira-automation/

 

Best,
Clark

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events