Children Status and Date as column of the Parent row in structure

Ee Kuan Wong
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 22, 2025

Hi All, I have a Structure, where I need to get the specific Task and component to show the STATUS and FINISH value by column at the "Objective" issue type. 

Example:
"BRD1 - Create" which have component "Create" to show it Status under "Create (Status)";
"BRD1 - Create" which have component "Create" to show it Finish under "Create (Finish)";
"BRD1 - Review1" which have component "Create" to show it Status under "Review(Status)" 
Screenshot_1.pngThe 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/Review1...)

IF (Issuetype="Objective", Max#children{Status})

The issue link between objective and task is "Objective of"

OR Can I have a structure without pulling the Task Level and still able to pull the task level status and finish value in? something like vlookup the value and have it at the respective column. The vlookup criteria can be as follow: 
Create (Status)= Get Status if Task is "objective of" the row, and component is Create

Thank you in advance :) 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events