I am trying to add some Custom calculated fields to JIRA that will automatically calculate Start and Finish times given inputs of a Start Date, Start Time and Duration in decimal format (0.25 = 15 minutes). I have found several plugins that would appear to do what I need but they are not available in JIRA Cloud.
Am I up S creek without a paddle or are there ways to do this in Cloud that I am not familiar with?
I have been looking at this problem as we have set up a risk register in Jira and needed to calculate the total risk value which is the product of consequence x frequency. It is only a 5 x 5 matrix but I have used the automation and setup a rule using the 'if' and 'else if' functions.
Start by creating 3 custom fields - Risk Consequence, Risk Frequency and Risk Rating.
Then using automation so that if the value of Risk Consequence or Risk Frequency changes the rule runs.
Then using nested If / If Else statements such as 'If Risk Consequence equals Catastrophic - If matches Risk Frequency equals very high, Then Edit issue field Risk Rating value = 25 unacceptable, Else If matches Risk Consequence equals High Then edit issue field Risk Rating value = 20 ...... and so on. Not a very clean way but it works for us.
Hi Alex, I know you found a way around this using Automation for Jira, but now it's possible to do exactly what you're looking for using smart values in Automation. They are really powerful https://support.atlassian.com/jira-software-cloud/docs/smart-values-math-expressions/.
Look out for an upcoming post on this! I'll link up here when we release it.
Hi James, this is possibly a little late for your needs, but it's possible to do what you're looking to achieve in Jira Cloud using Automation, which is available for free as long as you're using it inside a single project.
You can find some details here: https://support.atlassian.com/jira-software-cloud/docs/smart-values-math-expressions/
Product Update to clarity the above reference to JMWE:
Feb 5th 2021 released features in JMWE for Jira Cloud support calculated fields using Event-based actions. How-to example can be seen here.
Note: There are no execution limitations for JMWE for multi-project or global configurations, including in Jira Cloud Standard.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events