David Niro Atlassian Partner

You are very welcome! happy to help!!

Hello @Emily Urbanski , You are very welcome! Yes, this is definitely possible. We just need to add another variable for the condition and add the result to the first modifier. Something like this: with value_search = ARRAY("label 1","label 2","label 3"): with modifier_1 = labels .FILTER(value_search.CONTAINS($)).SIZE():…

Hello @Emily Urbanski , I believe the reason for the error is that after the first IF function, it should be ELSE IF. Something like IF condition 1: value1 ELSE IF condition 2: value2 ELSE IF condition3... However, based on the description of your goal, IF conditional statement probably will not return the desired results.…

Hello @LivCpope , It is not possible to create a new board from a structure. This would need to be done using one of @Dave Mathijs ', or your suggested approaches. Which reports are you planning to use? I believe we have a dev task related to reporting that I can add your vote to. Best, David

Hello @Manol Krastev , Welcome to the Community! Please reach out to our support team directly via email support@almworks.com or customer portal support.almworks.com. We may need to ask for screenshots to help understand your set up. Look forward to hearing from you. Best, David

Hello @Bhavani Mahesh Bhrugubanda , I understand now. Thank you for the clarification! This is not possible to do today, but I will pass this idea on to our product team. Could you please reach out to us directly via support@almworks.com or support.almworks.com? It would be great to hear more about your use case. Best,…

Hello @Bhavani Mahesh Bhrugubanda , It is possible to save Quick Transformations but it does require that you have Control access to the structure you are trying to save them to. Please let me know if this helps! Best, David

Hello @Victor Crespo , The problem with the expression was the destination will not recognize the variable p in that way. I'm not 100% sure I am clear on the goal, but perhaps this adjustment will return what you are hoping for: with p=issuelinks.filter($.source.project="PA").source: with…

Hello @Roland Peer , You are very welcome. Thank you for the clarification. In order to accomplish this, or something close, we would need to filter by formula attribute. At the moment, on Structure Cloud. We do have a task in our backlog related to it and I will add your vote. Best, David

Hi @Rama , History can be accessed in Structure on-prem. It is not yet available for Cloud. Do you know which you are on? If you are hosting on-prem, it would be helpful to understand more about the field and exactly what you are looking to show. Is this a select list multiple choice? Are you looking to show just the last…

Hello @Sam , David from ALM Works here. It is possible to do by using the copy and paste options at the top of the structure, or by using the copy and past keyboard shortcuts. If the generators used are similar, I would recommend looking into using a Group generator to accomplish your goal. It is best to keep the number of…

Hello @Roland Peer , David from ALM Works here. Welcome to the Community! I'm not sure I am clear on the goal. It looks like you have an Issue Type with a number of Sub-Tasks underneath it. Are you trying to show only the Issue and Sub-Tasks where at least one is "IN REVIEW"? In other words, what we see in your screenshot?…

Hello @sarathgd , In order to use resource leveling, you must first define the value to be used as a resource in the Gantt Configuration. The linked documentation will outline exactly how to do this. Best, David

Hello @sarathgd , This should work: with link_filter = issueLinks.type .FILTER($ = "Blocks" OR $ = "Depends") .UNIQUE() : IF link_filter.SIZE()=2: link_filter It looks at the number of elements the original formula returns and if it is = 2, then it returns the values. Best, David

Hello @Parveen Taj , So glad to hear it! You are very welcome! You can use this formula: with sp_size = sprint.SIZE() : IF sp_size >1: CONCAT( "{color:red}",sp_size,"{color}" ) Make sure to change the format from General to Wiki Markup for it to work. I also made an adjustment that shows the number of sprints rather than…

Hello @Parveen Taj , Thank you for the clarification! You can use a formula like the one below to identify the issues that are part of more than one sprint: IF sprint.SIZE() > 1: 1 If you are using an on-prem version of Structure, which it appears you are, you can also Filter by this formula. You can add a Generator or…

Hello @sarathgd , You are very welcome! Thank you for the additional information! This modification should work: If(Assignee != undefined; Assignee.name; Assignee = undefined; "No Assignee") This asks for the name rather than the key when returning the value. Hope this helps. Best, David

Hello @Parveen Taj , David from ALM Works here. Are you trying to create a structure that includes only stories that are included in multiple sprints? Or, are you trying to mark/identify stories that already exist in a structure and are assigned to multiple sprints? Best, David

Hello @sarathgd , Are you receiving an error or the values are all "blank"? Rather than saying "Empty", you will want to use undefined, like this: If(Assignee != undefined; Assignee; Assignee = undefined; "No Assignee") I can't say for sure if it is the reason you are encountering an issue though. What version of Jira and…

Hello @Tristen John Bagain , David from ALM Works here. From the screenshot, I can see you are using our product, Structure - Flexible Jira Project Management. It is not yet possible to Group, Sort, or Filter by the Team field. We do have a task related to adding this functionality and I will add your vote. I will be sure…

Hello @Tristen John Bagain , No apology is necessary! We have documentation related to Progress Column that can be found here. Best, David

Hello @Jayadev , Thank you for the clarification. Based on what you have mentioned, the proposed formula itemtype = "version" is the right solution. That it's not working for you is strange. To check what itemtype = should be, please add a new formula column to your structure and add only itemtype. It should look like…

Hello @Ronald Kopecky , David from ALM Works here. It sounds like you are using our product Structure - Flexible Jira Project Management. If I have this right, then it is not yet possible to add a column that would indicate if an issue has an attachment. You can submit your suggestion for Structure enhancements from within…

Hello @Jayadev , You are very welcome. Glad to hear it worked for you! How I can restrict this logic to only Project group level? Do you mean only Release level? If so, we can refine the !issuetype piece of the formula (see below). If not, I assume that the Project has multiple releases with different "statuses". How would…

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,…

Hello @Tristen John Bagain , Yes, it is true for all other fields used for weight. It is a weighted average calculation which is: ∑(WF*V)/∑WF Where WF is your your Weight Factor (here story points) and V is your Value (here progress). The only things that would change would be what you define as your Weight Factor or…

Hello @sarathgd , We just need to adjust the FILTER slightly. This should work: issueLinks.type .FILTER($ = "Blocks" OR $ = "Depends") .UNIQUE() Please let me know if it helps. Best, David

Hello @Tristen John Bagain , You are very welcome! I see two things that are happening here. The first is the 20% should be 30%, making the SUM of your Progress 950%. The second is how undefined values are handled. If an issue has an undefined value (blank) in the field you are considering for weight, the progress…

Hello @Jayadev , You're very welcome! Thank you for the additional info. The item property reference we will want to make are .isarchived and .isreleased. These will return a 1 if true and a 0 if false. Since we want to make the calculation at the Fix Version level of the hierarchy, we will use this rather than fixversion.…

Hello @sarathgd , David from ALM Works here. For this, you will want to use the UNIQUE function. The formula below should work for you. issueLinks.type .FILTER($.CONTAINS("Blocks")) .UNIQUE() Please let me know if this helps. Best, David