Hello fellow JIRA experts,
Question for you,
I am trying to use an IF statement to return values for the component field:
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
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.