Trying to convert a select list to numbers to use in a calculation but getting null

[kazu okamoto]

Im trying to associate a select list field options as numbers using the variables in my automation rule but I seem to get null results. I referenced an article showing an example of this being done on Data center. Im wondering if the syntax is supposed to be different on cloud. Here is an example of what I have for 1 of my variables.

Final action is edit "Rice Score" field with  

{{#=}} {{Reach}} * {{Impact}} * {{Confidence}} / {{Effort}} {{/}}

Reach variable

{{if(equals(issue.customfield_20039.value, "1 Team"), "1", if(equals(issue.customfield_20039.value, "10 Teams"), “2”, if(equals(issue.customfield_20039.value, "Most Teams"), “5”, if(equals(issue.customfield_20039.value, “All Teams"), “10”))))}}

[Bill Sheboy]

Hi @kazu okamoto -- Welcome to the Atlassian Community!

First, I recommend using a Lookup Table for this type of field mapping: https://community.atlassian.com/t5/Automation-articles/Update-Create-lookup-table-action-improvements/ba-p/2427798

This would allow getting the number in one step:

{{varReachValue.get(issue.customfield_20039.value)}}

Next, in your smart value expression, there are some curly / slanted quotation marks, and those are likely causing problems within the nested conditional expression.

Kind regards,
Bill