Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Structure: IF statement in Formula for Multi-value Components Field

Hello fellow JIRA experts,

Question for you,

I am trying to use an IF statement to return values for the component field:

IF (
Component = "DATA"; "Data Analytics";
Component = "Enhancement"; "Enhancement";
Component = "COMS"; "Communications";
Component = "NETS - OPS"; "Operations";
Component = "C&R"; "Research"
)

This works if the component field only has one value. However it does not return anything if the component field contains DATA and Enhancement. It simply leaves it blank. Any suggestions on how to write an IF statement that can return either the first value or both values in a scenario like this? 

Thanks in advance for your help

Bernard

1 answer

1 accepted

Hello @Bernard Horowitz ,

Thank you for sharing your Structure Formulas question here on the Atlassian Community

Here is an example formula you could use as a template:

 


IF (contains(components, "DATA") = 1; "Data Analytics";
IF (contains(components, "Enhancement") = 1; "Enhancement";
IF (contains(components, "NETS - OPS") = 1; "Operations";
IF (contains(components, "C&R") = 1; "Research";
IF (contains(components, "COMS") = 1; "Communications")))))



Please note that this formula will work only on the latest versions of Structure (V7.0 +). 

Basically, it is checking your components and will return the first value of the list using the name you need to show.

Also, here you can find more information about Formulas and Arrays:  https://wiki.almworks.com/documentation/structure/array-functions-115289495.html

Please let me know if it helps.

Best Regards
Dionathan L
[ALM WORKS] 

That works! Thank you. Now I have to play with it a bit. Fantastic. Thanks for taking the time!

Like # people like this

@Bernard Horowitz please "Accept answer" when you are fully satisfied with @Dionathan Lopes _ALM Works_'s response.

In this way, others reading this post will know this is the right solution. :) 

Best,

-dave

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

How we use Jira Service Management for our recruitment process! - Part 2

It is never about setting up a process and being done with it. Rather, the focus should always be on optimizing it for the best outcomes. Thus, we didn’t stop at setting up JSM for our recruitment pr...

180 views 0 5
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you