Convert from string to number in Jira board custom Fields

gtez

I am building a series of custom fields populated with three values each (e.g. 3-5-8) and a final "Result" field populated automatically with a formula taking the value from each of the previous field.

The Result field is built like this:

*Final Score:* {{#=}}
ROUND
(
(
{{issue.FPB - Business Value}} +
{{issue.FPB - Protect Value}} +
{{issue.FPB - Reduce Cost}} +
{{issue.FPB - Avoid Cost}}
)
* {{issue.FPB - Estimated Effort}}
, 0
)
{{/}}

My question is: Instead of showing the numerical value in the input fields, I would like to see something like Low/Medium/High.

The Final score formula should then associate to each response string a value number, e.g. Low=3, Medium=5, High=8 and compute the Result field.

Any idea how to do this?

guismb

Hey eZIO, I think there are more than one way you can accomplish this. You can have a multiple selection on the custom fields and then "translate" then into number when you'll get the result formula, something like (not sure if the syntax is correct, just the concept):

var x = 0;
if({{issue.FPB - Business Value}}==="Low"){
 x = x+3
}

And then add the others conditions as well to have the medium and high plus the other fields.

Hope this helps.