Can you do date calculation like in Excel for due dates in Jira

Almighty Drake

I have created custom fields for my issues which display parameters for the calculation of a due date, which I want  to be set automatically in a custom field  based of the parameters.

Is this even possible?

In Excel for sure.

For Example these parameters will someone put in into an issue:

2025

Week 25 (out of 52) of the Year

"extended"

 

So That means 2025 plus 25 Weeks -> convert into a date and then substract 24 Month because of the word "extended" if it has any other word then it would only substract 12 Month and it equals the due date which i want to have set automatically on a custom field.

 

Is there any suitable automation I can use?

And How do I insert such a calculation?

Walter Buggenhout

Hi @Almighty Drake ,

Yes, you can perform complex calculations in automation, even with dates. Have a look at this support article on calculations in Jira automation with date and time. 

The logic is using so called smart values that you can insert when you use the edit issue action. Just select the field you want to update and set the smart value formula as the value of that field.

Though the syntax may seem a bit complex at first, don't get overwhelmed by it. There's plenty of examples of calculations on the page I linked above.

Hope this helps!