Updating original estimate based on a number custom field

[Melissa Focone-Ortiz]

We have a number type custom field that represents days and would like the original estimate field to be updated when this custom field is edited.

Example: 2 entered in custom field updates original estimate to 2d, .5 in custom field updates original estimate to 4h.

Currently when this rule runs I get results like this:

Update custom field to 2, original estimate is now 1w 1d.

Update custom field to .5, original estimate is now 2d.

Update custom field to 4, original estimate is 4h. 

What needs to be changed?

[Bill Sheboy · Accepted solution]

Hi @Melissa Focone-Ortiz 

What I hypothesize is happening is your custom field is being interpreted as "calendar days of hours" and then using your site instance hours/working day and days/week, it is converting.

• So your "2 days" = 48 hours, and
• 48 hours / (8 hours/working day) = 6 working days = 1 w 1 d

For a work-around try to be explicit and perform the conversion yourself, only entering hours in the Original Estimate field edit.

{{issue.customfield_12780.multiply(24)}}h

Or, adjust based upon what you mean by "day" in the custom field.

Best regards,
Bill

[Melissa Focone-Ortiz]

Thanks for replying @Bill Sheboy

Unfortunately after changing the the step to that the field is still not updating correctly. This is what I get back now:

Enter 2 in custom field,  original estimate updates to 1d 4h
Enter .5 in custom field, original estimate updates 1w 1d

[Bill Sheboy]

What value did you put in the field value for the edit?

And, please check your site settings to see what the value is for Time Tracking "Working hours per day" and "Working days per week".  I believe the defaults are 8 hours/day and 5 days/week.

[Melissa Focone-Ortiz]

So first I put

{{issue.customfield_12780.multiply(24)}}h 

 but realized it should be 8, since the custom field unit of measure is 8-hour working days.

I changed it to 

{{issue.customfield_12780.multiply(8)}}h

It is working now, thanks!

[Bill Sheboy]

I am glad to learn it is working now.  Please consider marking this question as "answered".  That will help others in the community find solutions faster.  Thanks!

[Alon Shoham]

Hi, is it possible to sum up a few fields to show a single value in the original estimation?

[Bill Sheboy]

Hi @Alon Shoham 

As noted in this thread, if you have automation for Jira rules you could update the original estimate by performing math on other fields: add, substract, etc.

Automation rules are included with Jira Cloud and available as addons (free or paid license) for Jira Server/Data Center.

Kind regards,
Bill

[Alon Shoham]

Thank you Bill!