I have two projects X&Y, which will have multiple issues like EPIC>>Feature>>Story>>Task>Sub-task/s, in a structure.
Some of the Issues in each of these projects are blocked or depends which I am trying to show in a column by using below logic:
But the problem is - for some of the rows (different issue types) - entries in the column showing dependencies multiple times like - blocks, blocks, blocks etc
EPIC ---- Blocks, Blocks - my understanding is - since child entries of EPIC having blocks - here structure showing blocks more than once.
Feature - Blocks - means if i understand correctly - Feature is blocking EPIC
Stroy - Blocks - means if I understand correctly - Story blocking feature
My requirement is I want to show 'blocks' only once at EPIC/feature/story level though child entries have blocks.
Appreciate any help here.
Hello @sarathgd ,
David from ALM Works here.
For this, you will want to use the UNIQUE function. The formula below should work for you.
Please let me know if this helps.
Thanks David for quick help here. Now the structure shows Blocks and Depends when ever there is any dependencies.
By any chance will there be any case like both Blocks and Depends applicable between any issues type? Can that be achieved like -
$="Blocks" AND $="Depends"?
If apply this logic, none of either Blocks or Depends are appearing in the structure.
Hi @sarathgd ,
You are very welcome.
The formula should do, and does in my testing, the following:
IF there is at least one "blocks" link and no "depends" link: "Blocks"
IF there is no "blocks" link and at least one "depends" link: "Depends"
IF there is at least one "blocks" link and at least one "depends" link: "Blocks, Depends"
IF there are no "blocks" and no "depends" link: (blank)
(for all four, ignore other issue link types)
Is it doing something different for you?
If it is doing something different, you will want to contact our support team directly to review the behavior and identify potential causes. You can reach us via email email@example.com or through our customer portal support.almworks.com.
If it is doing what I describe above, then we will need to review your use case in more detail to understand all of the variables and end goal. Here too it may be best to contact our support team directly.
Hello @sarathgd ,
This should work:
with link_filter =
.FILTER($ = "Blocks" OR $ = "Depends")
It looks at the number of elements the original formula returns and if it is = 2, then it returns the values.