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
Start Date Update
When a work item transitions from Open → To Do, the Start Date is updated (JSON attached).
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!
