Calculated fields or restricting the value of a field based on another

Question

I'm looking to implement a 'score' for each story, which is a combination of the number of story points and the business value. Value will just be high medium and low, and worth 3, 2 and 1 respectively. One story point will be worth 10, two SPs will be 9, 3SPs worth 8, 5SPs worth 7 etc. Then it's just a multiplication of the two, so a high value one story point item will have a score of 30, a low value 5 point will be 7.

I've looked at a few plugins to do this, the only one I've found that is available for JIRA Cloud is ScriptRunner, but for $300 per month its a bit steep considering I'm only utilising a fraction of what that tool can do! I've also looked for something that can restrict values based on another field, e.g. if you select value of 'Medium', it only shows you 2, 4, 6 ... up to 20. You then enter 5SPs and it further restricts the field so the only option you have is 10, but I couldn't find anything to do this.

Does anyone have any other suggestions?

Richard Manthorpe · Answer

Thanks for your answer. As I mentioned, whilst your tool looks great, I can't justify paying $300 per month just to have a field calculated automatically, so I was looking for alternatives.

Kristian Walker _Adaptavist_ · Answer

Hi Richard,

Thank you for your question.

I can confirm that ScriptRunner for Jira Cloud will be able to implement the calculated field based on story points that you require. In order to achieve this you should use the calculated field example located in the documentation here and to modify this example to meet your requirements.

As for your second question unfortunately Script Runner for Jira Cloud is unable to restrict field values due to the limitations that Cloud provides as described here which means that it cannot provide the Behaviors functionality to achieve this that the server version provides.

If this answer has solved your issue can you please accept it in order to mark this answer as correct for users who are searching for a similar issue.

Regards,

Kristian