Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you might find the site temporarily inaccessible. Thanks for your patience. Read more.
×Have more fun with Kudos
- Collect badges and make progress
- Participate in fun challenges
- Climb up the leaderboard
- Gift Kudos to your peers
Community resources
Community resources
Community resources
- Community
- Tag: formula
Tag: "formula"
-
...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
-
-
I am trying to find a way to calculate the number of workdays and compare it to the sum of original estimate for each assignee in my sprint planning structure. The below formula is not w...
-
We have a field name labels which we use to tag our features. The label indicates the team which is working on the feature. In my structure view, I have created a hierarchy with Portfolio epics, Prog...
-
...et up Project Status in Form A to dynamically update to "completed" when the current date is greater than the end date. I have tried making Project Status a formula and pull NOW() to compare with t...
-
...nto the structure. However, I can't figure out how to write a formula to show what work was committed at the beginning of the sprint and what work was moved out during the progress of the Sprint....
-
I have a Jira structure that is returning Epic's under a certain condition which are extended to show issues belonging to Epics (Stories). Via a formula column i am trying to sum the n...
-
...sed as a grouping factor. I tried to find a way to implement, for example, a formula that would write commits as attributes in a Formula field. Can anyone advise if this is possible and what the formula...
-
I'm trying to put in place an automation between 2 JPD projects and I need to copy a value that is stored in a formula field to a number field
- Jira Product Discovery
- Question
- formula
- jpd
- number
-
-
Hello! I have the following hierarchy issues in Structure - TST-1 (type1) - TST-2 (type2) - TST-3 (type3) - TST-4 (type3) - TST-5 (type3) And I have such a need: if...
-
I tried to visualize in a wiki markup column with the following formula, however, it seems that there is no data returned in a column. Could anyone help me out with how to modify the formula and v...
Copied to clipboard
- FAQ
- Community Guidelines
- About
- Privacy policy
- Notice at Collection
- Terms of use
- © 2025 Atlassian