You may be experiencing slow load times on the forum; the team is working to resolve this ASAP.
×Community resources
Community resources
- Community
- Tag: formula
Tag: "formula"
-
...arent. I would like them in their own column. Even more specifically I'm hoping I can get the list of children as an array to use in formulas. Note: I am *not* talking about Epics and their children.
-
Hello! I have a structure formula column where I want to show an array of open issues of a certain type. We have a custom issue type called Risk. When I use the following formula I get all the l...
- App Central
- Question
- formula
- structure
-
-
Hello! I have a structure formula column where I want to show an array of open issues of a certain type. We have a custom issue type called Risk. When I use the following formula I get all the l...
- App Central
- Question
- cloud
- formula
- jira
- jira-cloud
- structure
-
-
Can I add OR in below formula to add the different type of issue links and put more AND Original formula: WITH _format(issue) = """[${issue.key}|${issue.url}]""" : issuelinks .FILTER...
-
Hello, I am trying to show the variance between the sum of Original Estimates compared to the sum of Time Spent rolled up to the Epic. I'd like to color-code the result of the variance outpu...
-
In jira structure, doing a structure column formala with "DATETIME(duedate)" gives an error, only shows "VALUE!". How do I get the timestamp value of duedate?
-
Hey Structure gurus! I've been getting a lot of value out of highly customized Structure Board columns using Structure formulas, however debugging and troubleshooting the syntax is a bear and I...
-
I am currently using the premium feature for Connections in JPD. My hierarchy is Initiatives -> Epics. On the Initiative I have a weighted formula (lowest score will get 0, the idea with the h...
- Jira Product Discovery
- Question
- connections
- formula
- jpd
-
-
Hi Atlassian Community! I want to share Risk Radar, a Jira Cloud app I recently created to help teams assess the risks of issues in Jira. In this post, I’ll explain how the formula calculates t...
- App Central
- Discussion
- calculation
- formula
- risk
- risk-management
-
-
...reate" to show it Status under "Review(Status)" The closest formula that give me result with no error is this but is inaccurate because missing filter by component of the child (e.g. Create/R...
- App Central
- Question
- cloud
- formula
- jira
- jira-cloud
- structure
-
-
I'm trying to find the right formula for the Impact Score. I'm considering Business Value, Customer value and Strategic fit as positive factors. I want to include Effort as a negative, but I...
- Jira Product Discovery
- Question
- formula
- impact
- jpd
-
-
Hi! I get the wrong date after using FORMAT_DATETIME(timestamp, "dd.MM.YY"). Example two times: 1722459600000 and 1735592400000 The first time is translated correctly and it is "01....
-
We would like to apply formatting rules (like the ones for numeric fields) in the formula fields. Is this possible somehow or is this feature not available?
- Jira Product Discovery
- Question
- formatting
- formula
- jpd
-
-
Frustrated switching back and forth between Excel and Confluence? As a project manager, you need to make informed decisions quickly to ensure all the moving pieces stay on track. When you’re setting ...
-
Hi, I have a formula that shows the end & start dates of a task based on the sprint start & sprint end dates. However, there are cases where an item carries over and is completed in m...
- Jira
- Question
- cloud
- formatting
- formula
- jira
- jira-cloud
- +1 more tag...
-
-
I have a custom formula column that helps me determine all the dependent issue links for a given item in Jira Structure. Now I need to know what is the maximum due date of the linked issues. C...
- Jira
- Question
- cloud
- formula
- jira-cloud
- structure
-
-
...roject target (or any other due date/deadline) as input to the score formular. With the the score would be impacted directly by a given due date. Idea 2: Use an automation which runs r...
- Jira Product Discovery
- Question
- formula
- jpd
- priority
- score
-
-
Hi! I have an issue hierarchy: Initiative Epic Task Epics are linked to Initiatives with Parent Link (from Advanced Roadmaps) and Tasks are linked to Ep...
-
Hello, i have a field called "Start Date", a date field (no time) another field "Sprints Estimation" which is number field. i want to set a value of another date field - "Finish Date" to b...
- Atlassian Automation
- Question
- automation
- formula
- smart-value
-
-
Hi, I hava a structure that is grouped by: - Fixversion - Team I am trying to count the sum of original estimates of issues resolved in each fixversion. Now my formula looks like this: IF (R...
-
...ixversions += Release1.1, fixversions -= Release1.2 Structure formula applied = history.changes.filter($.field="fixversions").toText Actual Output = Release1.1 Expected Output = Release1.1,Release1.2...
-
...he bundled column "Linked Issues" that returns all outgoing issue links: However, when I use a "formula" column and refer to Issue Links some outgoing links, remote links, are o...
- Jira
- Question
- data-center
- formula
- jira
- jira-data-center
- structure
-
-
Hello, I'm looking for structure formula syntax that I could use to change the color of the text in my formula column to red if the final result of the calculation is > 80%. I can't f...
-
...o, according to the example below, the Initiative's phase should be Design, because all its child issues with phase= Design have been resolved. However, this formula gives the value "Integration" b...
-
Hello everyone, I have an ARRAY with alphabetical values in a structure formula. And I have a second ARRAY, also with alphabetical values. Both ARRAYs are sorted. I want to output the values f...
- Jira
- Question
- data-center
- formula
- jira
- jira-data-center
- structure
-
Copied to clipboard