nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automate "Target Date" field when ticket is moved to "In Progress" AND has Story Points populated.

unknown

Hello! I am looking for guidance on how to configure a particular automation.

I'd like the automation to do the following: Upon the user moving Story/Task to "In Progress", the Target Date is populated with the forecasted date based on Story point logic.

For example, if 1 story point = 5 days, the logic on the backend of the automation would configure the "Target Date" field for 5 days from now upon moving the story/task to "In Progress".

Is this possible?

Accepted answers

Mikael Sandberg

Yes that is possible and fairly simple to do. All you need to do is trigger on the transition to In progress, check if story points exists and if so use the if/else condition to set the due date using this smart value {{now.plusDays(x).jiraDate}}.

All comments

Mikael Sandberg

Just change the x in the smart value to the number of days you want to set the due date to, for example {{now.plusDays(5).jiraDate}} if story point is 1.

unknown

Thanks so much, Mikael. What happens when the story point is 2, for example? Will it calculate that the Target date needs to be 10 days out (2 story points x 5 = 10 days)?

1 story point = 5 days

2 story points = 10 days

Etc.

Or do I need to create separate automation for each # of story points? Looking for a formula that can take the # of story points, using the logic of 5 days = 1 story point, and add it to the "Start Date", to then populate a "Target Date" accurately based on a number of story points.

Mikael Sandberg

In that case you could use math expression with a smart value to get the number of days that should be added to the due date. Something like this:

Screenshot 2023-01-26 at 1.10.54 PM.png

And then use that as part of the smart value to set the due date like this:

{{now.plusDays({{days}}).jiraDate}}

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

automation