How do you set dates for an issue by using a custom LOE field and linked issue?

[Nathaniel Elliott]

We are looking to make some project management in Jira Work Management simpler for our team. In short, as a project manager, I want the ability to update a "Due Date" OOTB field and have linked items adjust their due date based on the LOE field (# days) and the due date of the original ticket. 

Some thoughts: 

• I've seen a lot of articles about this but when I look at the smartvalues, I'm having a hard time implementing the condition of the LOE. 
• Example: ticket-1 has a due date of 2/14/2023, there is also ticket-2 which is linked as "must be done after" ticket-1. The LOE on ticket-2 is 5 so I would want the due date on ticket-2 to be 2/14/2023+5d so 2/19/2023 (and I don't want it to count weekends). 
• I've started on a few automations but keep coming back to issues. 

[Bill Sheboy]

Hi @Nathaniel Elliott 

For a question like this, please post an image of your complete automation rule, images of any relevant actions / conditions / branches, an image of the audit log details showing the rule execution, and explain what is not working as expected.  Those will provide context for the community to offer ideas.  Thanks!

Until we see those...

The date increment is the easy part for your rule, as you can may use the plusBusinessDays() function: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-plus-unit---

Regarding which issues to update, you can try branching to the linked issues with the specific type of note.  Here is where it gets tricky: how many issues are in your chain of issues with these dependencies?  If it is several, a rule like this may need to trigger other rules, cascading the updates.  That can lead to complications and rule failures for longer chains, due to performance and service limits of automation rules.

Please add any details you can for the scenario so the community can offer suggestions.  Thanks!

Kind regards,
Bill

[Nathaniel Elliott]

Reference material I've found thus far: 

• Examples of using smart values with dates | Cloud automation Cloud | Atlassian Support
• Solved: Setting Due dates based on another date field usin... (atlassian.com) -> {triggerissue.Activity Date.minusDays(16)}}
• Solved: Automation rule to update dates of linked issues a... (atlassian.com)
• Solved: How to automatically set the issue due date based ... (atlassian.com)
• Solved: Can you use automation to set due dates based on o... (atlassian.com)