Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Can I use IF statements in formulas for custom fields?

Ryan_Milway March 13, 2025

Are we able to use IF statements in custom formula for custom fields?

It looks like this functionality is available in Jira but it's not clear to me if the same functionality is in Jira Product Discovery.

Whenever I try to write an if statement, I get an "invalid expression" error or "could not parse expression".

 

Some additional context on what I am trying to accomplish:

I want the value of {Custom Field 2} to be derived based on the ranges of values from {Custom Field 1}

If {Custom Field 1} <=6 , then {Custom Field 2} = 1

If {Custom Field 1} >6 and <=12 , then {Custom Field 2} = 2

 

If {Custom Field 1} >12 and <=18 , then {Custom Field 2} = 3

2 answers

1 vote
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 14, 2025

Hi @Ryan_Milway -- Welcome to the Atlassian Community!

Custom formulas do not support conditional logic yet.

As a workaround, you could use an automation rule to set the field.  Please look here to learn more: https://support.atlassian.com/cloud-automation/docs/jira-cloud-automation/

Kind regards,
Bill

1 vote
Amina Bouabdallah
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 14, 2025

Hi there - we don't have conditions in custom formulas today. Noting down the feature suggestions!

Best,

Amina

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events