Jira Structure - Flag items with unresolved items

[Aldrin Rego]

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

[Stepan Kholodov _Tempo_]

Hello @Aldrin Rego 

Please clarify:

- what is the hierarchy of issues in your structure - is it only Epics or their issues are added to the structure under their respective parent Epics? 
- are descendants of Epics are connected with Epics via the Epic link or there is a link of another type is involved?
- do you have Jira Server/Data Center or Jira Cloud?

Best regards,
Stepan Kholodov
Tempo

[Aldrin Rego]

- hierarchy is epic—> stories > tasks—> sub tasks 

- descendants of epics are connected via epic link 

- jira server/ data center

[Stepan Kholodov _Tempo_]

Thank you. You can try this formula for indicating when all issues of an Epic are done but the Epic is still unresolved:

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

If you set the Format to Wiki Markup, the flag emoji will be returned for Epics. You can replace it to a text indicator and add color to it if needed.

As for the remaining Story points formula - you can try this one:

if issuetype = "story" and remainingstorypoints = 0 and status = "in progress": "{color:red}flag{color}"

The remainingstorypoints variable should be mapped to the Remaining Story points column where the values are calculated.

I hope this helps. If you need further assistance, please reach out to us directly at our support portal.

Best regards,
Stepan Kholodov
Tempo

[Aldrin Rego]

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.

[Aldrin Rego]

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]

@Stepan Kholodov _Tempo_ 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?