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