nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need help with Automation Smart Values

Mark Ewart_l39rjv

I am working on an objective-ish valuation calculation for projects (epics).

I have cusom fields that I need to sum up. I need to update a seperate field with that value.

In some cases, I need to take a string and pull the first 2 characters as a number.

I have searched youtube and the atlassian domumentation to no avail.

Are there training materials that illustrate hows to do this?

Accepted answers

Kian Stack Mumo Systems

@Mark Ewart,

Can you explain the use case just a bit more? Maybe some sample values you need to sum up?

Thanks,

Kian

All comments

Kian Stack Mumo Systems

@Mark Ewart,

Can you explain the use case just a bit more? Maybe some sample values you need to sum up?

Thanks,

Kian

John Funk

Hi Mark - You can use Automation For Jira to take a stab at that.

You might need multiple number type custom fields though if you need to convert a string to another number first.

Mark Ewart_l39rjv

I have two sets of custom fields that represent the breadth of impact and the depth of impact of a project (epic). I multiply those two outputs together to get the final calculated value.

I used to do this in script runner but it overloaded my log files so I had to turn them off.

1st set of custom fields - Breadth of Impact variables:

Custom field (% Agencies)

Custom field (% Internal)

Custom field (% Marketplace)

Custom field (% Supply)

Custom field (Breadth of Impact Value)

Breadth of Impact Calculation

Custom field (% Agencies) + Custom field (% Internal) + Custom field (% Marketplace) + Custom field (% Supply) = Custom field (Breadth of Impact Value)

2nd set of custom fields - Depth of Impact variables:

Custom field (Corporate Alignment) // = if no then 0, if yes then 2.0

Custom field (Standard/Diff) //= if no then 0, if yes then 1.5

Custom field (Internal Vulnerability Reduction) //= if no then 0, if yes then 2.0

Custom field (External Vulnerability Reduction) //= if no then 0, if yes then 2.0

Custom field (Increased Revenue) //= if no then 0, if yes then 2.0

Custom Field (Initiative) //this is a string that has a two (2) digit leading number. If none then 0, else 11-(left 2 characters from the string)

Custom field (Custom field (Depth of Impact Value)

Depth of Impact Calculation:

Custom field (Corporate Alignment) + Custom field (Standard/Diff) + Custom field (Internal Vulnerability Reduction) + Custom field (External Vulnerability Reduction) + Custom field (Increased Revenue) + Custom Field (Initiative) = Custom field (Custom field (Depth of Impact Value)

Value Calculation Variables:

Custom field (Breadth of Impact Value)

Custom field (Custom field (Depth of Impact Value)

Custom field (Calculated Value)

Value Calculation:

Custom field (Breadth of Impact Value) * Custom field (Custom field (Depth of Impact Value) = Custom field (Calculated Value)

Kian Stack Mumo Systems

@Mark Ewart

The Breadth of Impact calculation is fairly easy to do.

Create a new automation with the trigger of Field Value changed and set the fields to % Agencies, ect.

Use the Edit issue fields action and set the Breadth of Impact using the smart value as follows:

{{#=}}{{issue.% Agencies}} + {{issue.% internal}} + {{issue.% Marketplace}} + {{issue.% Supply}}{{/}}

The next one you posted is a little harder to do, but still workable. Try this:

Create a new automation rule with the same trigger as before, and the fields that it listens for are the Corporate Alignment, ect custom fields that you defined earlier.
Set up 6 actions of the Create variable type and define them all as 0. Doing this will allow you to default them to 0 and update them later in your rule if the field is populated.
After creating a variable for each field, you'll need to create 6 If/Else conditions: Make sure they are if/else blocks so that if the fields are not populated the rule will finish running
Each of these If/else blocks will check to see if the value exists. If it does, update the value of the variable as follows:
The only one that will be different is the Initiative field you mentioned earlier. To check that one, you want to do an Advanced check and check to see if it begins with two numbers. You can do that like this:
Then, to set the value for the initiative variable you should have defined earlier set up the action as follows:
Finally, after all of your If/else blocks, set the value of your Depth of Impact field with the following smart value:

{{#=}}{{corpAlignment}} + {{standard}} + {{ivr}} + {{evr}} + {{increasedRevenue}} + {{initiative}}{{/}}

Note: Please pay careful attention to the spelling or else it won't work. It took my a few tries to get all the spelling right and it working, so try it a few times if you're having trouble with it!

Mark Ewart_l39rjv

I thank you, my company thanks you and my wife thanks as I have spent many sleepless nights working on this!

Stay tuned!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud