Jira Automation smart value not working for Due Date calculation (Start Date + Original Estimate)

[SandeepSingh R]

Hello Community,

I’m working on automation rules in Jira Software and need some help with calculating the Due Date based on Start Date and Original Estimate.

---

✅ Working Rules

1. Start Date Update
   When a work item transitions from Open → To Do, the Start Date is updated (JSON attached).

2. End Date Update
   When a work item transitions from Any Status → Done, the End Date is updated (JSON attached).

Both rules are working correctly.

---

❗ Requirement (Not Working)

I want to automatically calculate the Due Date when:

• Start Date is populated

• Original Estimate is set

---

⚙️ Current Rule Configuration

• Trigger: Field value changed → Time Tracking

• Condition: Start Date is not empty

• Action: Edit issue fields → Due Date = (formula below)

Rule Name: Rule 4 — Auto Due Date

---

🧪 Formulas Tried

Option 1 — Using custom field ID:

{{issue.customfield_10015.plusBusinessDays({{#=}}{{issue.originalEstimate}} / 86400{{/}})}}

Option 2 — Using field name:

{{issue["Start date"].plusBusinessDays({{#=}}{{issue.originalEstimate}} / 86400{{/}})}}

Option 3 — Simplified:

{{issue.Start date.plusBusinessDays({{issue.originalEstimate}} / 86400)}}

Option 4 — Alternative syntax:

{{issue."Start date".plusBusinessDays({{issue.originalEstimate}} / 86400)}}

Option 5 — Epoch-based calculation:

{{#=}}{{issue.Start date.epochSecond}} + ({{issue.originalEstimate}} / 86400 * 86400){{/}}

---

❗ Issue

All of the above formulas are failing when the rule executes. The Due Date is not being updated.

---

🔍 What I Need Help With

• Correct way to reference Original Estimate in automation

• Whether Original Estimate should be accessed via timetracking.originalEstimateSeconds

• Proper method to calculate Due Date = Start Date + Original Estimate (in business days)

• Any working smart value examples for this scenario

---

💡 Additional Context

• I understand that Original Estimate is stored in seconds, so I attempted conversion using / 86400

• Still unable to get a working result

---

Any guidance, corrections, or working examples would be greatly appreciated.

Thanks in advance!

[Marc -Devoteam- · Accepted solution]

Hi @SandeepSingh R 

Just on top of my head.

You can try: {{issue.customfield_xxxxx.plusBusinessDays(issue.originalEstimate.devide(86400))}}

Otherwise I think you can store the value of "Original estimate" in a number field, so calculate this to a whole number and store this in a number field.

Then set the Due date as {{issue.customfield_xxxxx.plusBusinessDays(issue.customfield_xxxxx)}}

Or you might be able to store the whole number calculation of "Original estimate"  in a variable.

Then use: {{issue.customfield_xxxxx.plusBusinessDays({{variable}})}}

Do use customfield ID, if you have multiple "start date" fields in your instance.

[SandeepSingh R]

Thank you Marc, I had built another one , its working for me, now i have check for Time logging