David Niro Atlassian Partner

Hello @Jurica Petricevic , Is "customer" a single-select pick list on the project ticket? Is it the summary of the work package? Is it only ever one "customer" on each? I'm thinking we can FILTER() the issuelinks array and return the source "customer" then compare it to the project ticket customer. I'll need to know a…

Hello @yun_ , Welcome to the Community! You can certainly update the Sprint by double clicking on it in a structure. That being said, it does need to be editable and added to the edit screen. We have some instructions on how to accomplish that here. If you are still experiencing an issue after double checking the field…

Hello @BMueller , @Johannes Strodel & @Andrea Roßkamp [Communardo] , I have a great, slightly belated, update to share on this topic!! It is now possible to add Work Logged from Timesheets as a column in Structure! This is true for both Cloud and On Prem (Structure 8.3) hosted environments. I hope this finds you well!…

Hello @Paul Doman , Do I understand correctly, that you have some issues in your structure and that you have then grouped them based on some criteria where each issue can be under more than one group? Group A issue 1 issue 3 issue 4 Group B issue 1 issue 2 Group C issue 3 issue 4 And that now, at the issue level, you want…

Hello @Milan Pekař , Welcome to the Community! Apologies for the delayed response. You could try something like this: history.changes .FILTER($.field = "status") .LAST().changegroup.author It makes use of the History item property and Array Functions to get the last status update and then return the author of the change.…

@Lexi , this would be my suggestion as well. Is it working for you?

Hello @James Roy , Welcome to the Community! Apologies for the delay. I believe it's the Date format that is causing a problem here. It looks like you are using dd/mm/yyyy. Try mm/dd/yyyy, it worked for me in my testing. Please let me know if it helps! Best, David

you're very welcome!

Hello @Steve Battung , You are correct, the Remove Inserter/Extender duplicates filter is not yet available on Cloud. What we typically recommend is to avoid introducing issues via your Insert Generator that you plan to introduce via an Extend Generator later on. So for example, if you plan to use the "Issues under Epics"…

Hello @Lexi , What you are looking for is "undefined". IF column_A = undefined: column_B Hope this helps! Best, David

Hi @Petra , I believe we can help come up with something. But we will need a little more information about your set up and how you would like the calculation made. Could you please reach out to our support team directly via out customer portal support.almworks.com? Best, David

Hello @Sal , The sum over sub items options is just for adding up the values in the column. It sounds like you are trying to calculate the progress of a "parent" issue based on the progress of its children. To accomplish this, it needs to be built into the formula. Something like: SUM#children{progress} / SUM#children{1}…

Hello @Petra , I'm not sure I understand the goal. It sounds like you want to consider the WSJF value a % completed if the issue has been resolved. Or do you mean that at the Strategic Theme, you want to consider all of the sub items WSFJ value as 100% and treat each sub issue's WSFJ value as a fraction of the 100%? To…

Hello @Bernie Wu , What level is your group for "Group each issue under issue that derivation is it" set to? If it is set to "all levels", this may explain the problem. It would be trying to group things where the relationship does not exist. Please check and adjust the level to match the one the issues you want to group…

Hello @Eugene Nechaev , Welcome to the Community! I could not find the specific resolution to this request. However, you should be able to get to what you need using the Issuelinks item property reference and the FILTER array function. Something like: issuelinks.FILTER( $.type.outward = "yourissuelinkdirection"…

@Jozsef Lehocz , please do send an email as @Dave Mathijs suggests. Please also feel free to use the Data Center option if you decide to use the portal. Best, David

Hello @Bernie Wu , Welcome to the Community! Could you share the generators you are using and how specifically they are set up? Best, David

Hello @takuya kanematsu , Welcome to the Community! It's always ok to ask a question here!! Do I understand correctly that you are using Structure.Gantt by Tempo? If I have it right, the functionality isn't specific to Gantt, but to Structure. We have some documentation on how to Copy a Structure and Clone the Issues…

Hello @Marta Glass , It depends on what hosting type you are on. If you are on Server or Data Center you could create a Formula to identify the latest target end date of the child stories and then use an Attribute to Issue Field Effector to push the value to the target end date of the Epic. If you are on Cloud, this…

Hello @Dubie , If I understand correctly, you're looking for something similar to Text to Columns functionality in Excel, correct? If I have it right, this is not currently possible. Please feel free to share your idea here. Best, David

Hello @Andrew Adams , I believe this may be a result of your Insert Generator and Extend Generators pulling in the same issues. This can usually be resolved by refining the Insert Generator to only pull in a very specific set of issues. For example, if the problem is that Epics are being added by the Insert Generator and…

Hello @Mykola Bilenko , The formulas below were the end result. I do want to make sure that I reiterate that these are all potentially VERY heavy operations in their own right, so I would recommend testing that they work well together without performance issues in a staging environment before adding them to your production…

Hello @shkim , Welcome to the Community! For this, I would recommend contacting our support team directly via our customer portal, support.almworks.com. We will need to review your hierarchy and goals in more detail. Best, David

Hello @Tommy Heyser , I believe the CONTAINS() function should work for you in this case. You should be able to string it together with what you already have, like this: $.destination.labels.CONTAINS("Modules") Please let me know if it helps! Best, David

Hello @Sanjivani Wayal , Please reach out to our support team directly via our customer portal support.almworks.com. We will want to see screenshots of the entire structure with any generators in use visible and all columns in frame. Please also make sure that some issues are present in the screenshot (you can redact…

Hi @Tim Zhu , Sorry, I'm not sure I understand the question. Do you mean a query that can identify the MIN date of related issues and add it as a column? Outside of Structure I do not believe it is possible. But you can create a Structure to have the exact view & calculations you would like and then add it as a Gadget to…

Hi @Sanjivani Wayal , For the fields in question, could you please click on the column header and check if you have Sum over sub-items option available to you? It should definitely be there for Original Estimate. SInce your Folder should now be at the top of the hierarchy, you should get an aggregate of the values below.…

Hello @Tim Zhu , That's great! I'm glad to hear it is working. 1. For this you will want to use the SEARCH() function. Something like this: IF issuetype = "Initiative": MIN#children{ IF statuscategory != "DONE" AND SEARCH("your_text";Summary)!= undefined: target_end } 2. Formula columns created in Structure are not…

Hello @Sanjivani Wayal , It's difficult to tell what could be the cause based on the screenshot. Could you please share the formula you are using? Best, David

Hello @Sanjivani Wayal , IF is a conditional statement that can be used in formulas. The solution is the same. You just replace your_formula_here with the one you want to use, in this case an IF conditional statement. with _currentEstimate = IF originalestimate : (originalestimate) Else : (presaleestimate) :…