David Niro Atlassian Partner

Hi @Becky Brignall ! I can help with this :) We will want to use the background color (panel) functionality of Wiki Markup. In the formula below, I've taken your original formula and saved it as a local variable (issuelinks_filter) using WITH. The second part of the formula adds the background color to the results of the…

Hi @Raul Diez ! Well done!! Thank you for sharing!!!

I'm in the same boat. There are a good number that line up for me as well, but a few that are not so accurate. The best is the "dislikes". I laughed because it was funny and then cried a little because it was true... :D

WOW that is a lot of new Community members! Welcome everyone!!!

Hello @Sriram Pallapothu , David from ALM Works here. I saw that you contacted our customer team regarding this and Stepan was able to provide the solution. I wanted to add the solution here for other Structure users, that have the same question, to find. The following script will archive all structures where the owner is…

Hello @Raul Diez , David from ALM Works here. Is the goal to have the colors match the RAG status, or just to have the text "Red", "Amber", "Green"? If the former, this functionality is not yet available, but we are working on it! If the latter, could you share a bit more about the deliveryRAG field? Is it a Select List…

Hello @Benson Ho , Thank you for letting me know. Your email was flagged as spam for some reason. Someone should be in touch with you soon. Best, David

Hello @Yevgeny Alshitz , Please reach out to our support team directly via support@almworks.com or through the customer portal support.almworks.com. We will be happy to review your set up and provide additional guidance. Best, David

Hello @Yevgeny Alshitz , Did you have a chance to review the documentation I linked previously? It describes how to use Sprints for scheduling in the Gantt chart. Best, David

Hello @Benson Ho , Welcome to the Community! Please contact our support team directly via email support@almworks.com or through our customer portal support.almworks.com Best, David 

Hello @Yevgeny Alshitz , David from ALM Works here. Have you adjusted the Gantt Configuration to Use Sprints for Manual Scheduling? If not, the linked documentation should help get you started. Best, David 

Hello @Andrew Gioe & @Mukund Iyer Rajamony , David from ALM Works here. If I understand correctly, the goal is to add a column to your structure that will return the Issue Key for any issues that are linked to the current issue by a specific issue link. If my assumption is correct, some formula enhancements introduced in…

Hello @Ilan Barel , David from ALM Works here. For this it is best to contact our customer support team directly via email support@almworks.com or customer portal support.almworks.com. When you reach out it will be helpful to know your Jira base url as well as if the Structure was also migrated, but at a different time…

Hello @Matthew Mallard , Granularity just helps to define the length of the bar section. If you leave it blank, it will default to the barCounts variable defined earlier in the formula. Feel free to reach out to our support team directly via email support@almworks.com or customer portal support.almworks.com. Best, David

Hello @Matthew Mallard , David from ALM Works here. Are you currently on Cloud or on-prem? We have some useful formula examples in our wiki. I believe the Customizable Progress Bar may be what you are looking for, if you are on-prem. If you are on Cloud, we would need to modify the formula to remove the wiki markup items.…

Welcome to the Community, @Molly Couch !

Hello @rupert.schreder , What you are running into here is that even though you see "Unresolved" in the Resolution field, it is actually not defined. Please try this adjustment to your formula: SUM{If(resolution = undefined;1)} Let me know if it helps! Best, David

Hello @Ovidiu Ostafi , David from ALM Works here. At the moment, there is no Public API available for Structure Cloud. We do have a task in our backlog related to it though. I will add your vote to the task and will follow up with you here when there is an update to share. Best, David

Hello @Becky Brignall , David from ALM Works here. Welcome to the Community! We will need to look at how your structure is built and how you are going about adding the new issues to the structure. Could you please reach out to our Support team directly via support@almworks.com or through our customer portal…

Hi @Fanny Zucchinetti , You are very welcome! This seems to be the only way. However, maybe there is more to your use case that would be helpful to understand. Could you please reach out directly via support@almworks.com or through our customer portal support.almworks.com? You can reference this conversation and that I was…

Hello @Fanny Zucchinetti , Happy to help! Structure's Progress by Status calculation will only include the Statuses that have been defined in the column options. So, what we will want to do is; use or create a status that is not on this list. Then we can set the tasks to this status. In doing so, the tasks will be ignored.…

Hello @Fanny Zucchinetti , David from ALM Works here. Welcome to the Community! It looks like you are using an on-prem version of Jira and Structure. If this is correct, then the following solution will work for you. What we will do is use your original formula as a variable in another formula. This one will roll the value…

Hello @Billy Kelly , David from ALM Works here. Based on what you've described, it sounds like Formulas are not the solution you would need in order to accomplish your goals. I know you were trying to avoid it, but our suggestion would be to use Time Tracking, or to check the Marketplace for other Time & Team Management…

Hello @rupert.schreder , David from ALM Works here. Welcome to the Community! For this, you will want to use the DAYS_BETWEEN function to calculate the days between your created date and today. We can then compare this to your 4w, which we need to identify in days. It should look something like this:…

Hello @Alena Fricova , David from ALM Works here. You should be able to accomplish this through the use of a Formula. There is probably a nicer way of writing the formula, but the below seems to work for me. It looks at the current issue and the issue links. It then filters out the one you specify (the name, not the…

Hello @KE , David from ALM Works here. If I understand correctly, you want to show Open issues from a certain project and then show the Closed issues linked to them. Since you are using Structure, you can accomplish this goal by using an Insert Generator, an Extend Generator and a Filter Generator. You will start by adding…

Hello @Joachim Blaudek-Premm , David from ALM Works here. This is a similar limitation to what my colleague @Nicholas Ellis _ALM Works_ describes in this post . There is a limit to how far outside the current context you can pull in data with Expr. We can generally think of the context as the current issue In your…

Hello @Alvaro G orange , David from ALM Works here. Welcome to the Community! Please give this a try: IF(issuetype and plannedreleasedate <= actualreleasedate; concat("{panel:bgColor=#ADFF2F}",Format_Datetime(ActualReleaseDate,"dd-MMM-yy"),"{panel}"); issuetype and plannedreleasedate >…

@Brian Feeny , Glad to hear you worked out the issue link creation! Regarding the Manual Adjustments, I would advise turning that off and adding a Sort Generator instead. The two most popular ways are to sort by Rank (Jira rank) or Manual Reorder (this is different than Manual Adjustments. The former is useful if you want…

Hello @Jozef Vandenmooter , David from ALM Works here. You will want to use the Format_Datetime function for this. It will look something like this : setcolor(format_datetime(PID,"MM/dd/yy"), "#0000FF") I also adjusted the full formula here: WITH setcolor(value, color) = """{color:$color}$value{color}""": IF (…