Set start date relative to due date with automation

[Jordan Maris]

Hey,

I'm currently building my trello board, and I have a system that automatically cascades my checklist into cards, but I also want to be able to set cards start date programmatically.

What I want to achieve is:

when a card is added to the board with cardname starting with "special title", set start date three weeks before due date.

Any ideas how I can do that ?

Thanks :)

[Cody C_ · Accepted solution]

Good question, and this is something I've been looking to do myself. Right now, we can't use the Due Date's value as the starting point for other values in an automation.

The best workaround I've found is to use a Custom Field instead. Due dates can be set relative to a Due Date custom field. Here's what has worked for me:

when custom field "date" is set, set due date on the date in custom field "date", and set start date on the date in custom field "date" minus 21 days

Then instead of setting the Due Date, you'd set the custom field, which would then automatically set the Due and Start dates.

[Jordan Maris]

That got it, thanks!

[Martin Heineberg]

@Cody C_ I have tried this, but the system is not letting me put a minus (-60 days), It reverts back to zero. Any suggestions. 

[Cody C_]

@Martin Heineberg instead of using a negative in front of the number, try using the dropdown to choose either minus or plus and see if that works as you'd expect!

[Martin Heineberg]

Thank you, I figured it out. But contacted support and there is a bug in the software, and atlassian are looking into it. 

Thanks