David Niro Atlassian Partner

Hi @Tim Zhu , Please try this: IF issuetype = "Initiative": MIN#children{ IF statuscategory != "DONE": target_end } Instead of just returning the MIN{} of the children, it uses a conditional statement to define that it should only be using the dates from the issues that are not Done. Bold Italics is the new piece. You can…

Hello @Tim Zhu , Welcome to the Community! For this, you can modify the issuetype set by the conditional function and use the aggregate function MIN{}. Something like this should work for you: IF issuetype = "Initiative": MIN#children{created} Let me know if this helps! Best, David

Hello @Sanjivani Wayal , @Dave Mathijs is correct, we will want to add a Filter Generator. But first, it is important to understand your hierarchy and the generators in use. In your BP > Epic > BPT hierarchy, which has issues with no links to it? I assume either BP, Epic or both. What generators are adding the issues. For…

Hello @Sanjivani Wayal , This is due to how Structure's formula language considers the value of Original Estimate if it is not defined. Please try this modification to your formula: IF OriginalEstimate != undefined: OriginalEstimate ELSE: PresalesEstimate Let me know if it helps! Best, David

Hello @Sanjivani Wayal , At the moment, only Jira fields are available for use as variables in formulas (more here). From your description, it sounds like Current Estimate is another formula column. The workaround here will be to use a local variable to define your Current Estimate value in the new formula. It would look…

Hello @Sanjivani Wayal , With Structure, the values are going to aggregate up the hierarchy, so adding a folder to the bottom of the structure will not return the desired results. However, if you were to move the folder to the top of your structure, you will get the aggregate for the issues below. Please let me know if…

You are very welcome! Glad to hear it worked for you! 

Hello @Alex Agn , Based on another post you made, I believe you are referring to a Structure column, Time in Status. The way it is calculated is in Calendar Hours. 24hr((32w * 7days)+5d)+14hr = 5510 I hope this helps. Best, David

Hello @JL , Adding a conditional function should help. For example: IF issuetype: your_formula Please let me know if this helps! Best, David

Hello @Alex Agn , In your scenario, are there Stories that do not Realize a Feature and need to be included in the structure? If so, would you mind if those Stories exist on the same level as the Features? My thought here is that you could modify your JQL Insert Generator: (Project = "ProjectX" AND issuetype(feature))OR…

Hello @Alex Agn , You will want to use the DATE_SUBTRACT function for this. It will look something like this: with feasibility_job_size = (200*(10/100)): DATE_SUBTRACT(deadline,feasibility_job_size,"days") Please let me know if this helps! Best, David

Hello @Egzon Be , Welcome to the Community! It is possible to show Releases/Versions at the top of your Gantt chart. You can do it from the Gantt configuration page, by adding the projects the versions are tied to in the FixVersion timeline settings. Please let me know if this helps! Best, David

Hello @Anupam Sinha , At the moment it is not possible to reference another formula column in a formula. We do have a task related to this and I am adding your vote. Best, David

Hello @Alex Pogan , Apologies for the delay. It is hard to say what could be the cause in this case. Please contact our support team directly via support@almworks.com or through our customer portal support.almworks.com . We can review all of your settings and try to determine the cause. Best, David

Hello @Robbie Edwards , At the moment, this is not possible to recreate in Structure Cloud. The formula was created using the Markup language where on Cloud it is Markdown and currently supports text formatting, color and emojis. Please feel free to share your ideas here in our customer ideas portal! Best, David

Hello @petter_selin , Welcome to the Community! Sorry to hear about the challenge you are facing. That little hand in the beginning of the line in Structure means that you have Manual Adjustments enabled. In most cases, it is best to leave this feature turned off, as it can lead to some unexpected behavior. There are some…

Hello @Mohamed Haj Hamido , Welcome to the Community! I will need to know more about what you are trying to do. How is the hierarchy of your structure built? At what level are you trying to make this calculation? What is "Estimated_Duration", a field or another calculation? From what I can see, you have a field called…

Hello @Jozef Vandenmooter , The look of the Manage Structure page is just different because you are on a newer version of Structure. I see the same thing, but do not encounter the sort issue you do. It will be best to troubleshoot your issue directly with our support team. We will need to ask for information and logs that…

Hello @Jozef Vandenmooter , If Rank sort is set to 2 and Status sort is set to 3, it should be working as expected. Could you please check if you have Manual Adjustments enabled for this structure? You can do this by following the "Mark Adjusted Content" steps outlined in the documentation I linked. If you do find that the…

Hello @Hadar Dinte , Welcome to the Community! At the moment it is not possible to Group by formulas in Structure Cloud. That being said it is one of the top items on our Roadmap. I have added your vote to the related task and will follow up with you as soon as it is released. Best, David

Hello @Julia M_ , Welcome to the Community! This should work for you: with _count = SUM#children{1}: with _format(text,color) = """{panel:borderStyle=solid|borderColor=white|bgColor=$color}$text{panel}""": IF _count = 0: _format("OK","green") ELSE IF _count < 10: _format("Check","yellow") ELSE: _format("Risk","red") Please…

You are very welcome! Glad to hear the solution works for you!!

Hi @Emily Russell , You are very welcome! I think I understand now. The Epic is not the parent, it is the child in this scenario. Thank you for the clarification! Do I also understand correctly that the Epics are part of project 'ABC'? I initially thought they were not part of this project. If I do understand this…

Sorry, forgot to also mention that you can select the Date/Time option (default is General) when creating your formula. This will save you the trouble of having to format the date/time in the calculation itself.

Hello @Joakim Wöntner , Please give this a try: with _childstatus = VALUES#children{status}: IF issuetype = "EPIC" AND status != "DONE" AND _childstatus != "DONE" AND originalestimate != SUM#children{originalestimate}: ":red_circle:" the with _childstatus is a variable that takes into consideration the status of each…

Hello @Emily Russell , Welcome to the Community! Can you please try the following?: 1) "Eng Execution Start" IF issuetype = "EPIC" AND project != "ABC": VALUES#children{startDate}.UMIN() 2)"Eng Execution End" with _def = key.FILTER($.MATCH("*DEF*")): If issuetype = "EPIC" AND _def != undefined:…

Hello @Marina Kotler , You are very welcome. Thank you for letting me know about the ticket. I just reviewed and it does appear there was some issue that was addressed earlier today. If you are still experiencing the issue, we can continue to investigate via the support ticket. Best, David

Hello @Marina Kotler , @Ashish Bijlwan picked the perfect place to start. Global Permissions is the best place to start looking. Since you have ruled this out, the next item to check will be the owner of the structure. When creating a structure, the generators "run as" if they were being searched by the owner. So, if the…

@todd_george , You should be prompted to pick one or the other when moving issues under an Epic. Is that not happening? Is it possible that some of the issues had both links for some reason? Best, David

You are very welcome!!