David Niro Atlassian Partner

@Io-Cheong HO , I believe you will want to add a Sort Generator and choose either the Sort by Rank or Manual Reordering option. Please give it a try and let me know if it helps! Also, feel free to contact our support team directly at support@almworks.com or through our customer portal support.almworks.com. Best, David

Hi @Io-Cheong HO , Could you describe the problem you are trying to solve? Are the issues sorted in some way that you don't want to see them? Best, David

Hi @Io-Cheong HO , It looks like your screen capture cropped off the column headers, which is where we would want to look. You will see three lines (small, med, large) on the left side of the column header if you are sorting by it. To quickly clear any column sorting, you can click on the Summary column header once. Best,…

You are very welcome @LaBulle22 ! I'm happy to help!!

Hi @LaBulle22 , That would be normal use of Expr. We have some documentation that describes Expr in some more detail here. Please also feel free to contact our support team directly via support@almworks.com or through our customer portal support.almworks.com! Best, David

Hi @LaBulle22 , Thank you for the additional detail! The format for creating a user function is described here. Line 1 in the example is the format for the function and Line 2 is that function in use. It's very similar to writing a local variable where you start the function with with and end it with : Possibly what you…

Hello @LaBulle22 , Could you describe what you are trying to do, in full? Understanding the use case will help in determining the best approach. Best, David

Hello @Parekh, Sanketkumar , That is because I completely misspelled it. Sorry about that. It is support.almworks.com Best, David

Hello Calvin ! It looks like you are using Structure for an onprem hosted instance of Jira. Since this is the case, you can reference the History in a Formula. Please try adding a new formula column and use this: history.changes .FILTER($.field = "assignee").changegroup .LAST().timeperformed It filters the history events…

Hi @Carla Bismuth , I work for the company that makes Structure. Please feel free to reach out to us directly via email support@almworks.com or support.almworks.com. We will be happy to review your goal and work out the correct query with you. Best, David

Hello @Parekh, Sanketkumar , Welcome to the Community! For this, please reach out to our support team directly via support@almworks.com or through our customer portal support.almworks.com. The durations that I have exported to excel all get exported properly. We will need to review your exact scenario in more detail. Best,…

Hello @lradomsk , At the moment it is not possible to reference Time in Status in another Formula. We do have a task in our backlog related to this functionality and I have added your vote. I will follow up with you as soon as there is an update to share. Best, David

Hi @Bernard Horowitz , Do I understand correctly that the Goals and Initiatives are not in the structure? If that's the case, we can get the summary from the Initiative since it is directly related to the Epic. We are not able to get the Summary from the Goal as it is two steps removed from the Epic. The formula for the…

Hello @Bernard Horowitz , Something like this formula may work for you : IF issuetype = "EPIC": PARENT#level=1{summary} That should return the Goal level and to get the Initiative level, I believe you would want to change #level=1 to #level=-1. Please let me know if this helps. Best, David

Hello @Monica Cuesta , Welcome to the Community! You could check the dashboard gadget and make sure that there are not any Filters applied to it that would remove the sub-tasks. If there are no filters, it will be best to work with our support team directly via support@almworks.com or through our customer portal…

Hi @venkatesh satish , Are you asking about Structure Effectors, as @Trudy P Claspill has asked? If so, it seems like you are using the Attribute to Issue Field variety and are trying to use it to populate a field that is does not have a value yet? If I have these pieces right, what are you using as your attribute, a…

Hi @Kazimierz Tyczyński , Sorry, I am still not sure I understand the goal, and can't provide an example. Could you please describe your goal in a User Story format? Something that would help me understand the business goal and what the different challenges and variables currently are? Best, David

Hello @Kazimierz Tyczyński , Glad to hear it! I'm not sure I understand the first question. Are you just trying to modify the values from the January column? If so, I think the approach would be to next January as a variable within the formula from image 2. You can next multiple formulas with a formula. Regarding the…

Hi @Karim ABO HASHISH ! I believe that @Parveen Taj may be using our product, Structure - Flexible Jira Project Management. @Parveen Taj , if I have this right, it is not possible to do at the moment. However, we do have a feature in our backlog that would allow us to do something like this in the future. Please let me…

Hello @Vini , Those options are not available for Cloud, which means you have an OnPrem hosted instance. The good news is we can use Transformations to Filter by Attribute. You will select Formula from the list. Your Formula will be: itemtype != "version" AND statuscategory != "DONE" AND PARENT{item.isreleased} Operator…

Hello @Vini , There is not a way to reference the progress from a Structure column in JQL. The only workaround is to remove the issues that have not yet been completed from the completed fix version. That being said, we may be able to Filter by Formula sometime in the future. This may present a solution to your use case.…

Hello @Kazimierz Tyczyński , Probably the easiest way to accomplish something like this would be to add work logged columns for the users. Then, in a new formula column, use the CALENDAR_DAYS() function to convert the values to the decimal format you are looking for Columns as Variables , make the extra calculation, and…

Hello @nanellepeyper , If Billed Time and Logged Time are both fields on your Jira issues, you can add a formula column and use: BilledTime - LoggedTime If BilledTime and LoggedTime show up in red, you can map them to the corresponding fields from the variable list below the formula box. Hope this helps! Best, David

Hello @Vini , You are very welcome. Thank you for the clarification. I think I understand now. As an example EPI22.11-Nov6 is a completed version, but we can see from the Progress column that the version still has at least one issue that was not completed. Your expectation is that there should only be issues that are…

@rupert.schreder , Re Timespan Month and Year calculation: For This Month , please use the formula below for _worklogs with _today = today(): with _monthstart = START_OF_MONTH(_today): with _monthend = END_OF_MONTH(_today): with _thismonth = ARRAY(_monthstart,_monthend): worklogs.FILTER($.startdate >= _thismonth.FIRST()…

Hello @rupert.schreder , * Data format of columns: you can change the option from General to Duration. This will format the value you see to the duration you are looking for. * Timespan: I see I misunderstood here "I want to show for each employee of the department how much work he/she has logged in last week, last month…

Hello @Vini , Welcome to the Community! Could you please share more detail about what your goal is? Are you trying to add only issues that are completed and then group by Fix Version, are you trying to only show issues that are part of completed sprints? I look forward to your response. Best, David

Hi @Rkeanefootball1! , Welcome to the Community! Could you share a little bit more about your goal? It sounds like you want to add a new column to the structure where the Task (parent) created date would show at the Sub-Task (child) level. Is this correct? Also, it would be good to know for sure if you are Cloud or On-Prem…

Hello @rupert.schreder , This is possible to do, and I have outlined the steps below. Before you attempt this in your production environment, you will want to test this thoroughly in your staging environment to identify any performance issues. Depending on the number of issues in your structure and the number of work logs…

Hello @yogesh bhatt , Welcome to the Community! You can make use of the Status Rollup Effector for this. The Effector on its own is not "automatic". It would require someone to run the Effector. However, you can set the Effector to run on a schedule using Scriptrunner and this script. Please let me know if this helps!…