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)" 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/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 :)