How to automate a custom date field of a subtask using that same subtasks due date field

[Josiah Ekong]

I have an automation that creates 3 different subtasks when a new issue is created. Each subtasks automates a due date based on different formulas.

I also want to automate adding a custom field date, which i named "results due", to each subtasks and want the custom field date to be 5 weeks before the due date for that subtask. 

I tried using the smart values: {{issue.dueDate.plusDays(35)}} but when I make a new issue the results due field is blank for all subtasks.

Any help?

[David Blank · Accepted solution]

Hi @Josiah Ekong ! 

Would you be willing to share a screenshot that shows where you are setting your custom date field?

I wonder if you are setting the custom date when you are creating the subtask, and it is possibly pulling the due date from the Task rather than the Subtask? Can you also confirm where you are wanting to pull the due date from(task or subtask)?

[Josiah Ekong]

Sure, here's a screenshot.

The due date is being set for the subtask and I want to pull the due date from the created subtask to calculate a date for Results Due Date

[David Blank]

@Josiah Ekong , it is possible that the Re-Fetch Issue Data Action could help here.

I would try adding the Re-Fetch Issue Data Action after your Create Issue, and then a branch, and then update the issue with your Result Due Date value. 

I'll try in my sandbox and report back.

[David Blank]

@Josiah Ekong I confirmed the assumption above. If you add a Re-Fetch Issue Data after you create the subtask and then create a branch rule for "Most Recently Created Issue" after that, you can update your custom date field.

Here's a screenshot of how I did it in my sandbox:

Note: I used Start Date in my example where you should use your custom date field.

[Josiah Ekong]

This worked.

Thanks for your help