I am encountering an error while trying to automate the calculation of story points in Jira using smart values based on custom fields. The custom fields involved are "Complexity", "Effort Required", and "Skill Required", each with dropdown options (High, Medium, Low). The goal is to calculate the story points as an average of these values, assigning numerical values (High = 3, Medium = 2, Low = 1), and then rounding the result.
Error Message
Error rendering smart-values when executing this rule: Failed to get value for ( (if(equals(issue.fields['Complexity'], 'High'), 3, if(equals(issue.fields['Complexity'], 'Medium'), 2, 1))) + (if(equals(issue.fields['Effort Required'], 'High'), 3, if(equals(issue.fields['Effort Required'], 'Medium'), 2, 1))) + (if(equals(issue.fields['Skill Required'], 'High'), 3, if(equals(issue.fields['Skill Required'], 'Medium'), 2, 1))) ) / 3.0 | round: {{ ( (if(equals(issue.fields['Complexity'], 'High'), 3, if(equals(issue.fields['Complexity'], 'Medium'), 2, 1))) + (if(equals(issue.fields['Effort Required'], 'High'), 3, if(equals(issue.fields['Effort Required'], 'Medium'), 2, 1))) + (if(equals(issue.fields['Skill Required'], 'High'), 3, if(equals(issue.fields['Skill Required'], 'Medium'), 2, 1))) ) / 3.0 | round }} }
Context:
I have set up the following custom fields:
- Complexity: Dropdown with options (High, Medium, Low)
- Effort Required: Dropdown with options (High, Medium, Low)
- Skill Required: Dropdown with options (High, Medium, Low)
Automation Rule Configuration:
- Trigger: Field Value Changed for the custom fields (Complexity, Effort Required, Skill Required).
- Action: Edit Issue Fields to calculate and set the Story Points.
Current Smart Value Expression:
{ "fields": { "Story Points": {{ ( (if(equals(issue.fields['Complexity'], 'High'), 3, if(equals(issue.fields['Complexity'], 'Medium'), 2, 1))) + (if(equals(issue.fields['Effort Required'], 'High'), 3, if(equals(issue.fields['Effort Required'], 'Medium'), 2, 1))) + (if(equals(issue.fields['Skill Required'], 'High'), 3, if(equals(issue.fields['Skill Required'], 'Medium'), 2, 1))) ) / 3.0 | round }} } }
Issue:
The above expression fails to execute, returning an error about rendering smart values. The goal is to correctly evaluate the custom fields, convert their values to numbers, calculate the average, and round the result to set the Story Points.
Request:
Could you pleaes provide guidance on the correct syntax or approach to resolve this error? Any insights into ensuring the smart values are correctly evaluated and the final result is computed accurately would be greatly appreciated.
Additional Context:
- Jira Cloud environment
- Automation rule set up through Jira’s built-in automation tools
- Custom fields are properly configured and visible on the appropriate screens
Thank you in advance for your assistance!
