Is Jira able to auto fill a field based on data that is inputted into another Field

Question

I am creating a Risk Management Project using Jira, our organization has a approved Excel template for risk management with cells that auto fill depending on other cells values IE the amount of days add to schedule section will auto fill the costs.

I have been trying to see if I can use JQL to automate filling these fields with the correct data but it seems that JQL doesn't have the capability make these calculations like Excel handles formulas.

I have been wondering if anyone has encountered this issue before and found a solution or if this truly falls out of scope for what Jira has been designed to do.

Trudy P Claspill · Answer

Hello @Ben Day-McDonnell

Welcome to the Atlassian community.

As @Calvin suggested you can use Automation Rules to set field values based on other field values. Automation Rules are triggered by events like Issue Created, Field Value Changed, and Manual or Scheduled triggering.

Another option is to consider a third party app that provides scripted custom fields. ScriptRunner is one such app.

https://docs.adaptavist.com/sr4jc/latest/features/scripted-fields

Calvin · Answer

Hay mate, I think you might be looking for automations

https://www.atlassian.com/software/jira/features/automation

https://www.atlassian.com/software/jira/guides/automation/overview

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/

You might see a automation button to create your own if you are a project or product/site admin.

In there you can have a trigger for when a field is updated (date), which then does some calculations and then edit the work item to put the data back into the other field (cost).