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

[Ee Kuan Wong]

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

[Stepan Kholodov _Tempo_]

Hello @Ee Kuan Wong 

you can add more conditions to the formula to consider only specific Tasks. For example:

IF (Issuetype="Objective", Max#children{if search("create", components): Status})

This formula will consider statuses of all Tasks that have the 'Create' Component, and return the latest one in the order for the parent Objective.

I hope this helps. If you need further assistance here, please contact us directly at our support portal, and we'll have a more detailed look at your setup.

Best regards,
Stepan
Tempo (the Structure app vendor)