Automations with due dates working backwards (due X days before final due date)?

[Arlene.Amaya]

Hi all, I'm trying to set up some automations for a project. If the entire project must be completed on X date, can I make it so that the start/due dates of other tasks are dependent on that? 

For example, a texting campaign that is due on June 15 requires task 1, 2, and 3 to be completed. Is there a way to input June 15 into my automation and have start/due dates for tasks 1-3 populate automatically based on them being due X days before June 15?

[Jack Brickey]

Hi @Arlene.Amaya ,

yes you can certainly set/adjust the Due Date field using Automation. However to assist wit details I need more info.

where does the "June 15" come from? Is it in another custom date field, e.g. "Project End Date" or are you going simply going to set this within the automation?

let me explain why this is important. If it is a static known date then the automation could simply set the date to say June 10. However if you want the project due date to be dynamic then it could be referenced in automation and set the issue due date to be x-days prior to the date in the custom field. As an example I think the automation for setting the due date would look like this - {{issue.project due.minusDays(5)}}

there are some good posts in the community about manipulating dates so you might wish to search around a bit.