Jira Automation to update Due Date field based on Story Points Estimate field and Start Date field.

Vineet.Kotian February 10, 2024

I want to update the Due Date field of a subtask based on the Story Points Estimate field and Start Date field by calculating Start Date + Story Points Estimate and assigning the date to Due Date field.

For eg
Feb 09, 24 (Start Date) + 4 (Story Point Estimate) = Feb 14, 24 (Due Date)

My Rule:
1. Issue Trigger:
     - Issue Transitioned - To Do - In Progress
2. Conditions
     - Issue Type = Subtask
     - Due Date is empty

3. Edit Issue fields
  - Using Smart Value for Due Date field {{issue.fields.Start Date.startDate | plus: (issue.fields.Story Points * 1) | date_add_days: (issue.fields.Story Points * 1)}}

I tried this rule but it didnt give the desired result. Any help with modifying my rule will be be greatly appreciated.

1 answer

2 votes
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 10, 2024

Hi @Vineet.Kotian , so you are equating story points to time, 1 SP = 1 day? That is unusual. Story points generally convey a level of size/complexity. If you want time based estimates why not use Original estimate?

with that said let's try to get your rule working. Ike unsure how SP will be translate TBH.

you mentioned you did not get the desired result. What is the result? Does the rule fail or does the duedate give the wrong date? 

just off the top of my head without checking syntax or testing I offer the following.

{{issue.Due date.plusBusinessDays(issue.story points)}}

 

Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 10, 2024

It may be the 1 SP ends up translating to 1 second. if that is the case and you want one story points equal one day you would have to multiply story point by 86,400. 

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 10, 2024

Hi @Jack Brickey 

First, I agree with your ideas about story points usage.  And...

@Vineet.Kotian asked about setting the Due Date from the Start Date.  Your example seems to show the opposite: adding to the Due Date.

Kind regards,
Bill

Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 10, 2024

Yes indeed! Thanks for keeping things accurate @Bill Sheboy . So I guess it would be...

Due date equals 

{{issue.Start date.plusBusinessDays(issue.story points)}}

 

Amr Selem October 22, 2024

@Jack Brickey can i edit this to be story point /2

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events