Formula to support in/not in operation

alwaysharsha November 3, 2021

If the structure formula can support in/not in operations it would simplify the formula creation/usage.

Currently, we would need multiple if conditions for simple operations shown below.

Currrent Scenario: 

if(
(safepi = 'PI13' AND status = 'planned' AND safecommitment = 'Committed'), "Yes",
(safepi = 'PI13' AND status = 'planned' AND safecommitment = 'Uncommitted'), "Yes",
(safepi = 'PI13' AND status = 'in progress' AND safecommitment = 'Committed'), "Yes",
(safepi = 'PI13' AND status = 'in progress' AND safecommitment = 'Uncommitted'), "Yes",
"No")

 

Updated Scenario:

if(
(safepi = 'PI13' AND status in ('planned','in progress') AND safecommitment in ('Committed','Uncommitted')), "Yes",
"No")

If we support in/not in operations the usage would be simplified further.

 

1 answer

1 accepted

1 vote
Answer accepted
Dionathan Lopes {ALM Works}
Atlassian Partner
November 3, 2021

Hello @alwaysharsha 

Dionathan from ALM Works here.

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

 

IF ( JQL{
safepi in ("PI13") and
status in ("Planned", "In Progress") and
safecommitment in ("Committed","Uncommitted")};

"Yes"; "No"
)

 

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

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events