How to setup an automation with 2 date fields sum?

[Vitor Seabra]

Hello there! I'm setting up a new automation but I have no clue on how to make it works using Jira Smart Values.

What I basically need is to sum the Original Estimation field value (i.e: 2w) with the Start date value (i.e: March 20, 2023) taking in consideration business days (i.e: 2w = 10 b.d) so the result would be the Due date value (ex: March 31, 2023).

Does anyone could help me out with the right expression?

Thank you in advance.

[Bill Sheboy · Accepted solution]

Hi @Vitor Seabra -- Welcome to the Atlassian Community!

I believe the Original Estimate is stored as seconds, and so if you divide that value (based on your site settings for work days/hours) into whole days, it can be added to your field with plusBusinessDays()

{{issue.yourField.plusBusinessDays(yourIncrementValue)}}

Kind regards,
Bill

[Vitor Seabra]

Thank you Bill!

Just one further question: My Start Date field name is customfield_10015 (which is weird, once I thought it was a native field). The Original Estimate field name is timeoriginalestimate. So the proper expression for this formula would be:

{{issue.customfield_10015.plusBusinessDays(timeoriginalestimate)}} ?

[Bill Sheboy]

You will need to divide the estimate value to convert seconds to working days first:

60 seconds/minute x 60 minutes/hour x 8 hours/work day = 28,800 seconds/work day

{{issue.customfield_10015.plusBusinessDays(issue.timeoriginalestimate.divide(28800))}}