Simple automation for the sum of 3 custom fields

Max_Clark March 11, 2024

hi everyone - im looking at doing some WSJF automation - currently want to get the sum of 3 custom fields

so far i have the below rule - its runs successfuly but nothing happens :(

COD1.JPGCOD2.JPGCOD3.JPG

2 answers

1 accepted

1 vote
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 12, 2024

Hi @Max_Clark 

Smart values for fields are name, spacing, and case-sensitive, and they sometimes do not match the displayed name on the issue views.  When an incorrect smart value is used, it collapses to null, and often fails silently with no rule errors.

I recommend confirming you have the correct smart values for your fields, using this how-to article: https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/

Kind regards,
Bill

Max_Clark March 12, 2024

this was what i was missing - ended up using the {{issue.Customfield_xxxx}} and it started cooking Thanks

Like Bill Sheboy likes this
1 vote
Dominic Williamson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 11, 2024

@Max_Clark A few things to check with your syntax.
Here's the automation I have for a working global automation for WSJF calculation:

Screenshot 2024-03-12 at 11.54.28 am.png

Variable name: WSJFvalue
Smart value formula

( {{issue.Risk Reduction}} + {{issue.User Business Value}} + {{issue.Time Criticality}} ) / {{issue.Job Size}}

 Then
Screenshot 2024-03-12 at 11.56.39 am.png

 Edit the WSJF field

ROUND({{WSJFvalue}},2)

This will round the value to 2 decimal places.

Using this does it now work for you?

Max_Clark March 11, 2024

thanks! ive added the IF all match section - and for this particular task im trying to calculate cost of delay  ( i have a 3rd party app calculating wsjf) so just the total sum of business value, time criticality and risk - the automation is showing its passed and it edited a field however nothing actually populates in my COD field

Dominic Williamson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 11, 2024

@Max_Clark Did you use the formula provided above?
This automation does not use additional apps. You can calculate using values from the custom fields shown above.
The IF check was not the focus. It was the "Then create variable" formula. 

You can also use the formula it as a reference how to calculate other fields, eg CoD. As mentioned, your formula syntax looks different to mine, see documentation.

Hope this gets it working for you!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events