...hildren like Epics). eg: Here are the formulas I would normally use in Structure column >> IF issuetype = "Feature": MIN#children{ &n...
Hello. I'd like to create a formula on structure where: If Due Date is Late and StatusCategory is Not Done, appers RISK if due date is on time and statuscategory is not done, it is Normal if d...
I use this formula to check is something is scheduled past due date with parentDueDate = parent#level=5{duedate}: with latestReleaseDate = fixversions.releasedate: IF (issuetype = "Child" A...
Hi, how to get status of parent issue next to the child. by the parent link I get only link to the parent. parentlink.status - does not work
...he opposite, descendant of link. Formula: We’re trying to access the dueDate value of the Task’s Goalpost, to tell us if it falls inside the Sprint’s endDate or if it’s past. We w...
For a given issue, I want a structure formula column to display the total for each of the different issuelinks.type for that issue. Basically the equivalent of a UNIQUE_COUNT. I can use U...
Does anyone know how to return remote/web links of a Jira issue with a Structures column, specifically via formula? The Structures "Linked Issues" field returns them but also returns any and every o...
...ompleted their work. I need a formula column to calculate the time between the date and the status please
I am trying to find a way to present the difference between current progress% and previous progress % (in a custom field) with a structure formula. Currently I have this formula for a p...
HI! I have a formula that writes issue key and summary of all linked issues to a column: "WITH _format(issue) = """[${issue.key}|${issue.summary}]""" : issuelinks .FILTER($.type = "Contribute" A...
...ira parent-child linkages and other using advanced roadmap parent link which has "is parent of" linkage. So I am unable to fetch the 2nd one with the advanced roadmap linked issues. The formula u...
Hi! I'm trying to setup a structure in which I want to visualize the "FEATURES" with below all the users with the time they registered on that feature-ID E.g, ARTABC-123 (Feature-id) ...
Hi! Is there are way to fetch the summary of a parent issue (linked to an feature with parentLink) with structure formula. With this formula I can get the issueKey but not the summary? &n...
HI, I'm trying to find a way to mark parent features in my Structure that have any children that are linked to a capability. Currently my formula looks like this and it marks the linked i...
Hey All, I need help with a structure formula for total sprint capacity before the sprint starts (team members x days of sprint). I have this formula but it calculates total remaining c...
Hi : This is the scenario, where I need help. I am using a formula column to sort and pick the latest fixversion. The fixVersion are stored as "YY.MM.DD" and can have multiple values. I am t...
...eature 4 is assign to Team A and it has 5 child stories. But there's 1 story assign to Team B. How do I get the formula to work so that Team A total story points reads as 10 and not 11? C...
Hi, As a result of the custom formula in the structure I need to get the date when the issue was in status1, if this issue was not in status1 at all I need to see Status2. My formula l...
Hi to Everyone, I have two projects. The issue hierarchy is Capability/Epic/Story. Some of the Epics are broke down to Stories, some don't. Different teams are working on the projects and they measu...
Greetings, I am using a Formula field that's basically a duration counter, but I'd love it to show the values just in days and not in weeks-days-hours. is it possible to set a custom field f...
...f String values: Custom field (Smart Checklist Progress) 2/5 - Done 3/3 - Done 1/2 - Done 8/9 - Done Could anyone help me with the formula or syntax to use? Thank you a...
I'm trying to make a Formula column that will display the full name from a Notes column where I type in their username. See screenshot example: Basically, "Notes" column is a place to add p...
We have the following Jira hierarchy Initiative->Epics->Story. Few of the Epics may not have Initiatives and in that case it is Epics->Story. In my Structure Board, I need the Sprint to whic...
So I created a customized column that displays all tickets that are linked as predeccessors to the current issue. This is the formula: issueLinks .FILTER($.type = "successor p...
I need to group people based on discipline, but cannot use any grouping that is already in structure, so I must use a custom group formula. After a ton of trial and error, I believe I have found a b...
Copied to clipboard