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; } } }

Automation smart value. Converting list to numeric

Vadym Hrigorash

Hi All.
I have two projects. The first one is Product Discovery which has a field as a list with weights (every option contains some value). Second one is Software Project. I created automation rule with smart values to copy some field from PD project to Software. It works if PD field is numeric but does not work with field which is list of options with values. On the Product Discovery itself I can calculate this field and copy it to another field.
Any advice, please, on how to convert this field to a number? This field can contain more than one option. They all are summarized and copied to another field (on the PD project).
Help, please

Accepted answers

All comments

Bill Sheboy

Hi @Vadym Hrigorash

For a question like this, please post an image of your complete automation rule, images of any relevant actions / conditions / branches, an image of the audit log details showing the rule execution, and explain what is not working as expected. Those will provide context for the community to offer ideas. Thanks!

Until we see those...

When the rule gets those values from the multiple select, custom field, they are text. To convert them to numeric values use the asNumber function.

For example, to get the value for one selection use:

You note the field is multiple selection, and so the specifics of how you are using the values will determine next steps. Showing your rule and explaining further will help.

Kind regards,
Bill

Vadym Hrigorash

see below

Vadym Hrigorash

Hi @Bill Sheboy

Thanks.
I changed Smart value to {{issue.myCustomField.value.asNumber}} and now it does not fail. But, it returns Zero despite the weight of the chosen option is 47.

The first image shows type of field and weights of their options. It is a Product Discovery project, by the way. Rule should calculate those value and store to Software Project field.

Thanks, in advance

Bill Sheboy

Ah, this is a JPD project and you are trying to access the "weight" value which (I believe) is dynamically calculated across selected values for a set. Is that correct?

Vadym Hrigorash

I think it's not dynamically calculated. it's set constantly but this is a list of options with weights.
The first goal was to get dynamically calculated value as it works on JPD but I couldn't do it. So I took this formula and focused on repeating this calculation from JPD fields and store to Software Project. I will be able to do it if I can convert field options (with weight) to number. So, this is the my task and this was a question

James Smith_0hwvat

@Bill Sheboy OK, I'm an idiot and completely missed out one step, the NULL variable. Sorry to waste your time. Thanks for all this amazing work!

Bill Sheboy

Hi @James Smith

Did you mean to post your response in this thread or another one? Thanks!

Kind regards,
Bill

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-cloud

automation