David Niro Atlassian Partner

Hello @Shira Hanan , You are very welcome! Thank you for the additional information. Just to make sure I understood, the goal is to have the value from the Flag field included in the formula's return result? If I have understood correctly, something like this should be close: with FORMAT_CAPTION(color, caption, Flag) = (…

Hello @Becky Brignall , Do any of the issues return more than one result? If they only return one result, modifying the formula in the following way should help: with issuelinks_filter = issuelinks .FILTER( $.type = 'Cross Pod Dependency' AND $.source = this ): IF issuelinks_filter: concat(…

Hello @Andreas Gangwisch , David from ALM Works here. Welcome to the Community! At the moment, the allocation calculation does not take into consideration the work logged. We do have a task related to this and I have added your vote to it. Regarding workarounds; The one you have employed is the best option at this point. I…

You are very welcome, @Radim Drinka ! Glad to hear it was the solution!!

Hello @Radim Drinka , Thank you for the screen captures! The first one may offer the cause. The way Structure Permissions work is that the lowest permission on the list takes precedence. It may be that the user who is unable to reorder by rank is part of more than one group. Since the View permissions are at the bottom of…

Hello @Shira Hanan , David from ALM Works here. Welcome to the Community! Could you please provide some more detail about what the "Flag" is and where it is coming from? If you are looking to add a red flag to the end of the caption, you can do so with the formatting below. FORMAT_CAPTION("#d33",…

Hello @Radim Drinka , Does the user have Edit access in the Structure Permissions? You will be able to check this by selecting the Configure Option from the Manage Structures page. Also, it would be worth checking that the Sort Generator has the "Allow Changes via Structure" option enabled. Please let me know if this…

that's it! looks like I needed a page refresh before posting ;)

Hello @Don Utley , David from ALM Works here. Since we are trying to match the labels' value to "ABEA", we just need to add the MATCH expression. The formula below should return the values you are looking for: labels.FILTER($.MATCH("ABEA*")) Please let me know if it helps! Best, David

You are very welcome, @Uwe Döll ! So glad to hear it was the right solution for you! Best, David

So glad to hear it, Radim! You are very welcome!! Best, David

Hello @Vee , David from ALM Works here. Welcome to the Community! At the moment, this is not possible. We are still driving towards parity between the on-prem and cloud versions of Structure and have a task related to this. I have added your vote to the task and will follow-up with you here when there is an update to…

Hello @Uwe Döll , David from ALM Works here. Welcome to the Community! Your formula is 99% of the way there. There are two adjustments we can make to get it working for you. The first is to define diff as an expression using $ and to enclose the Text Snippet with """. With those two modifications, your formula should look…

Hello @Rama , David from ALM Works here. In addition to what @Brant Schroeder has suggested, you could also add a formula column to your structure that you can then filter by in excel. For example, if you need to filter by Status, you could try this: IF (level != 1; STATUS; level ) Based on the hierarchy you describe, your…

Hello @Noa Tsruya , David from ALM Works here. Welcome to the Community! That sounds very odd. To work out what may be happening here, it would be best to do so directly with our customer support team. You can reach us via email support@almworks.com or through our customer portal support.almworks.com. Looking forward to…

Hello @[deleted] , Thank you for the additional information! We should be able to accomplish your goal with the formula below and choosing the Sum over sub-items option: IF( JQL{issuetype in (story,task,bug,improvement,newfeature) AND Status != Closed};1) Essentially it assigns a 1 to each of the issue types defined, that…

Hello @Piotr Turek , You are very welcome. Apologies for any confusion, I was providing a means to solve your use case via Structure. The reason for my bringing up Advanced Roadmaps is because you mentioned a "parent-child hierarchy" and we need to understand how that relationship was created in order to build your…

Hello @[deleted] , David from ALM Works here. It sounds like you have a Structure hierarchy of Program > Epic > Story/Task and that you are looking to SUM the count of Open Story/Tasks at the Epic and then Program levels. We would also want to SUM the count of Closed Story/Task at the Epic and then Program levels in a…

Hello @Segev Grotas , David from ALM Works here. Welcome to the Community! It sounds like you are using Structure - Flexible Jira Project Management. If this is the case, could you share how your hierarchy is set up and what it consists of? It would also be helpful to understand where the Test Repository is coming from and…

Hello @BernardH , David from ALM Works here. We will need to make use of a Formula column in order to accomplish this goal. How we specifically approach it will depend on your structure's hierarchy as well as where you would like the calculation (count) made. Could you share a screenshot, or description of your hierarchy…

Hello @Matthias Schindler , Welcome to the Community! "is caused by" and "causes" sound like the inward (destination) and outward (source) descriptions of the issue link you would like to use. Where you see "blocks" in the example formula above should be replaced with the Name of the issue link. If you have Jira Admin…

Hello @Cristian Caravan , David from ALM Works here. It is possible to do using the JQL embedded query , if you are using a version of Structure that is at least 7.0 or higher. There may be other ways to accomplish your goal depending on what you are looking to count and where you expect to see the result. Could you share…

Hello @Radim Drinka BS , From the screenshot, I can see that Manual Adjustments are still enabled for your structure. Please follow the steps for Undoing Manual Adjustments to correct the duplication. Best Regards, David

Hi @Radim Drinka BS ! That's great news! I look forward to your update :) Best, David

Hello @Radim Drinka BS , You are very welcome. The goal is 100% feasible using Structure. What I am suggesting is that the use of Folders and Manual Adjustments is not the best approach for this specific goal. To accomplish your goal, you will want to use a Group Generator (which you have done) and a Sort Generator…

Hello @Radim Drinka BS , Glad to hear the customer likes the idea! From your screenshot, I can see the hand icon next to RAMS-388. This indicates that the issue was moved here through Manual Adjustments. Manually adjusted issues ignore generators and can be placed anywhere in the structure arbitrarily, which is why you see…

You are most welcome!

Hello @Paul Doman , David from ALM Works here. Welcome to the Community!! What version of Structure are you currently on? You can find this by clicking on the info button in the bottom right corner of Structure. The Array (.MAP) and Text Snippet (""" """) functionality in the example formulas above was introduced in…

I should also mention that you will want to start with an Insert Generator that defines the issue type you would like to start with. Additionally, any other criteria the first set of issues (stories) need to meet. something like Project in (ABC, 123, ETC) AND Issuetype = Story

Hello @Piotr Turek , David from ALM Works here. Welcome to the Community! How to accomplish this grouping is going to depend on how the "Parent and Child" relationship was established. If you are using Advanced Roadmaps to create the relationship, you can Group by "Parent Issue (Advanced Roadmaps)" which can be found…