Set Epic dates according to the earliest Story Start Date and latest Story Due Date

Question

Hello Community!

The need is to set dates on the Epic that starts on the earliest Story Start Date, and end on the latest Story Due Date, using Automation.

As I see it, I need the rule to run over all the Stories in the Epic and extract the correct dates, coping them to the Epic dates.

How can this be achieved?

Ayelet Ben-Tzur · Answer

Thank you Bill!

Actually - the sync is relevant only up - dates of the stories affect the dates of the epic.

Bill Sheboy · Answer

Hi @Ayelet Ben-Tzur

Thanks for the additional details.  I wonder if there are actually multiple issues here:

* You want the epic updated with the most recent information on start/due dates
* The epic is composed of multiple stories, any one of which could start at different time frames than the overall range of epic timeframe
* You want to update stories and have them update the epic (and possibly all of the sibling stories as well)

You could write a rule which syncs up and down (one story up to epic, and epic down to sibling stories), and I expect that would run into problems.  There is no guarantee of the execution order of rules or even the components within a rule; they run asynchronously.  Any up/down rule might lead to collisions or run-away execution.

The safest choice here is probably to always manually update Start Date and Due Date in the epic, and use one rule to sync down.  Or, accept the stories are out of sync and only the latest change *wins* in updating the epic.

Best regards,

Bill

Ayelet Ben-Tzur · Answer

Thank you Bill, that is actually similar to what I implemented, but there is a problem:

I have 2 stories, and the earliest start date for example is Jan 18. This date was copied to the Epic, and now the Epic will start on Jan 18. So far - great.

Now - I'm changing the start date of the story to Jan 20. This won't be copied to the Epic since the rule copies the date only if it is earlier than the existing date.

So now I have an Epic that starts on Jan 18 when no Story starts on Jan 18.

Any ideas?

Thank you!

Ayelet