Custom Formula Expression

[Ohad Orbach]

I have numerical fields and a checkbox (Boolean?) field.

I'm trying to make a custom expression field that will write a number if the checkbox is clicked, else do a formula with the numerical fields.

for example:

IF(checkbox, 100, {Impact} * 0.7 + ({Effort} * 0.3)

How can I do it?

working in Jira Product Discovery 

[Marc - Devoteam]

Hi @Ohad Orbach 

This is not doable in a custom formula, formulas can only use number field.

Use automation for this.

https://community.atlassian.com/forums/Jira-questions/Condition-to-see-if-a-specific-checkbox-option-was-checked-or/qaq-p/2337718 

And make use of smart values, that based on the checkbox is checked, create a variable with value 100 and then do a calculation.

You will need a custom number field to show the result of the calculation

[Ohad Orbach]

Hi @Marc - Devoteam 

Tried to use the automation but i keep getting an error message of "Edited work item successfully, however some of the set fields aren't available. Fields ignored: ..." on the custom number

tried to create it from the board, change manually the value all is working but keep failing.

also tried to open a new field from the fields area without getting this new field in the board and just updating his value in specific item manually which is working but the automation keep failing with same issue.