How to automate changing the sprint of blocked issues when the blocking issue's sprint changes?
I'm using the Plan Timeline to visualize dependencies for tasks planned for the quarter. We are linking dependent tasks and pre-populating them into the upcoming quarter's sprints where we think the work will start. We have hundreds of tasks, and would like to automate the sprint assignment of blocked tasks to be updated to match the delta of the change in the blocking task's sprint assignment.
For example
Task A blocks Task B; Task B blocks Task C.
Task A is assigned to Sprint 1; Task B is assigned to Sprint 2; Task C is assigned to Sprint 3.
When Task A gets pushed from Sprint 1 to TWO sprints out (to Sprint 3), I would like the linked tasks that Task A blocks to be automatically moved TWO sprints out from their current sprint assignments too. In other words, Task B will be moved to Sprint 4 and Task C will be moved to sprint 5.
I tried to play around with the automation options, but the closest I could come was below. It only lets me choose the next sprint and that's not exactly what I want. I want to maintain the sprint assignments for the linked issues, just bumped according to the blocking ticket's sprint change.
Any tips would be greatly appreciated!