Simple automation for the sum of 3 custom fields

[Max_Clark]

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 :(

[Bill Sheboy · Accepted solution]

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]

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

[Dominic Williamson]

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



Variable name: WSJFvalue
Smart value formula

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

 Then

 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]

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]

@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!