I am using Jira Cloud Automation to try and dynamically update a custom field when other custom fields are updated. Here is the basic logic:
Trigger: When value changes for: Custom_Field_1, Custom_Field_2, or Custom_Field_3
Then: Edit Custom_Field_4 to equal the sum of Custom_Field_1, Custom_Field_2, and Custom_Field_3.
If: Custom_Field_4 is greater than 0 but less than 6
Then: Edit Custom_Field_5 = 1
Else If: Custom_Field_4 is greater than 6 but less than 12
Then: Edit Custom_Field_5 = 2
The issue is that Custom_Field_5 ends up being calculated based off of the old value of Custom_Field_4, and not the new value which was calculated when this rule was triggered.
I will add that all of the custom fields I mentioned are number fields.
How can I resolve this?