Jira Structure - Flag items with unresolved items

Question

Would like a way to create a column called 'Issues' using Formulas in structure to flag using a particular color (perhaps using wiki markup) items that need attention to ensure good JIRA hygiene:

- Parent ticket (i.e issuetype = epic) is done (resolution is not empty) and descendants (stories, tasks, sub-tasks) are still open (resolution is empty) and vice versa, flag when all children are done and the epic is still 'In progress' or 'To do' or 'Planned' status (i.e.  (resolution is empty) )

- We use a JIRA structure column to calculate Remaining Story points on issue types= Story  and would like to flag when a Story is 'In progress'  but the 'Remaining Story points' value is 0

Aldrin Rego · Answer

@Stepan as of now #1 (flag when all children are done and the epic is still 'In progress' or 'To do' or 'Planned' status (i.e.  (resolution is empty) )) can be achieved using the following formula

with _childstatus = VALUES#children{status}: IF issuetype = "EPIC" AND status != "DONE" AND _childstatus = "DONE" AND sum#strict{if !resolved:1}: "(flag)"

Would you be able to help me with #2 and #3 below?

#2. is it possible to add the reverse to the above logic to add a flag when the epic is marked as resolved but the descendants (stories and tasks) are still unresolved

#3 is there a way to combine #1, #2 into one formula?

Aldrin Rego · Answer

I was able to flag epics that were still unresolved when all the children (stories, tasks and subtasks) were resolved using the following formula. Now I need help with adding #2 and #3 from my earlier post to this formula.

with _childstatus = VALUES#children{status}: IF issuetype = "EPIC" AND status != "DONE" AND _childstatus = "DONE" AND sum#strict{if !resolved:1}: "(flag)"

Aldrin Rego · Answer

Hi Stepan ,

1. if issuetype = "epic" and !resolved and sum#strict{if !resolved: 1}: "(flag)"

Is currently flagging items that have epic in progress, underlying story in progress and when some tasks under the stories are done while others are in progress. I would like it to be flagged when all tasks or stories under an epic are done but the epic is still is !resolved.

2. also is it possible to add the reverse to the above logic to add a flag when the epic is marked as resolved but the descendants (stories and tasks) are still unresolved

3. is there a way to add the story points formula into the epics formula above so that all the flags appear in one column?

Thank you for looking into this.