🚀 Now Live: Native Formula Fields in Jira!

[Esha Gajula]

Hi everyone,

I’m excited to announce that Formula Fields are now Generally Available in Jira Cloud! Formula Fields allow you to run real-time calculations directly on Jira work items. By automating these calculations within Jira, you can ensure data remains accurate and actionable without needing to export to external spreadsheets.

Key Capabilities

• Real-Time Calculations: Results update automatically whenever a referenced source field is modified.

• Searchable & Filterable: Formula results are fully supported in JQL, allowing you to use them in dashboards, automations, and saved filters.

• Multiple Output Types: Support for Number, Text, Date, and Duration outputs to cover use cases like risk scoring, status labeling, and due date management.

• AI-Powered Building: Use Rovo to generate formulas from natural language prompts or suggest corrections for syntax errors.

Admin Details

• Availability: Enabled by default across all Jira Cloud editions (Free, Standard, Premium, Enterprise).

• Configuration: Admins can create "Formula" fields in company-managed spaces or team-managed spaces.

• Stability: To ensure JQL and reporting stability, the output type (e.g., Number vs. Text) is locked at the time the field is created.

What’s Next?

As we move into GA, here are a few areas that are not yet supported in this release:

• Cross Work Item Rollups: Formulas currently run within a single work item — calculations that span across work items (e.g., rolling up values from child work items to a parent Epic) are not yet supported. We'd love to hear from you: How would you use cross-issue rollups in your workflows? Share your use cases in the comments!

• Select Fields: Referencing single and multi-select fields within formula logic is not yet supported. We're curious — how are you looking to use select fields in your formulas? Let us know in the comments!

Helpful Links:

• https://support.atlassian.com/jira-cloud-administration/docs/create-a-formula-field/

• https://support.atlassian.com/jira-cloud-administration/docs/supported-functions-for-formulas/

We’re excited to see how your teams use these new capabilities. Please share your feedback and use cases in the comments!

[Stephen Patterson]

A Select Fields use case: We currently have an automation that generates a "RICE score" where RICE represents a work item's Reach, Impact, Confidence, and Effort. Each of these is represented by a numerical value, chosen from a select list, and then, when all fields are populated, the conditions are met to then calculate a score, which is written to a "RICE score" field. The formula we use is (R+I+C)/E. It would be great to be able to use a formula field rather than depending on an automation for the calculation.