Formula in jira structure with issuekey

Question

I have a Jira structure over multiple items that share the same issuetype but not necessarily the same schema.
I have a formula that sums over a value for a field but some of them are missing this field.
For better or worse, while we can add this field to those projects, I want to hardcode the value using the formula in a new variable.

Something like

if(annualized_value != undefined; annualized_value;
issuekey="PROJ-123"; 200;
issuekey="MLP-3234"; 4000;
0)

However, the issuekey="PROJ-123" and MLP-3234 do not show the resp value on their lines for that new column.

What do I do wrong (besides hard-coding stuff...)?

marc_olivier · Answer

Thanks.
I exactly tried this

if issuekey = "CVML-227": 200

But it did not work (meaning the column did not have value 200 for the issue with key CVML-227 in my example screenshot).

I am kinda clueless...

I do not think issuekey has a space, though.

Stepan Kholodov · Answer

Hello @marc_olivier

The formula's syntax is correct, it should work. If it doesn't return the expected values, then maybe something is not matching - the issue keys are different, or the field is defined with an empty value, or something else takes place. You can try to troubleshoot the formula - for example, add a new Formula column with the formula: if issuekey = "proj-123": 200 and see if it works. If it does, then try the next one: if annulized_value != undefined: annulized_value else "1" and check if 1 is returned for the issue or not.

I hope this helps. If you need further assistance here, please reach out to us directly at our support portal and we'll have a detailed look at your setup.

Best regards,
Stepan
Tempo (the Structure app vendor)