AUTO CALUCATE DATES FIELDS BASED ON VALUES FROM ANOTHER DATE FIELD

[niranjan]

Hello Community, 

I need to solve this below scenario. Any suggestion apricated. 

1. Auto calculate the ETA of Documentation date by referencing the linked Issue Type Task. This process will use the Development Completion date from the Issue Type Task, add 5 business days, and then update the ETA of Documentation field in the Issue Type SFC TS accordingly. (start development transition)
2. Similarly, Auto calculate the ETA for Documentation Review date by using the ETA of Documentation as a starting point. Add 5 business days to this date, and then update the ETA of Documentation Review field with the final date. (transition - development completed)

Thanks

Niranjan

[Ryan M]

Hi Niran,

I haven't tested this fully but I think something along these lines should do the trick or be a good starting point.

Trigger

• Trigger when issue is transitioned between the statuses that are relevant as mentioned above. From (start status) to (end status).
  
  

Branch Rule

• Here's where we'll specify the type of linked issue. You can restrict it to link types and projects here if it helps.
• Branch Condition
  • If issue type = Task
• Branch Action
  • Then: Create variable 
  • create a variable using the date file from the issue found in the branch rule. 
  • Lets say name = linkedDate
  • smart value would be {{issue.yourDevCompletionDateField}}

Action

• Edit issue
  • Edit the date field in question, ETA of Documentation, with this
  • {{issue.yourETADateField.value.plusDays(linkedDate.asNumber)}}
    
    
    

Info for smart values and formatting here https://confluence.atlassian.com/automation/smart-values-in-jira-automation-993924627.html

[Ryan M]

Also if something is not showing up right, a tip in case you're not familiar would be to use the "log action" action to make sure your smart values/variables are appearing correctly. If you use log action and use your variables or smart values as the message, you can check the logs of any automation attempts and see if those are correct values, and if not troubleshoot further