Structures formula column: how to return a specific epic's child issue (textmatch)'s status?

[Marijn Plat]

Googling for 2 hours gave me mixed ideas as to whether this is possible, so I thought I'd give it a go on this forum.
I'm in a company-managed cloud project.

I'm trying to add a formula-column to a structure with only epics. In a certain formula-column, I want an expression to

first retrieve any children with a certain text match, in this case "step 1", and then
to retrieve the status of that child-issue.

I know that with the formula

VALUES#children{key

I can retrieve children's data, such as keys and summary. So far, I haven't gotten much further than returning ones and zeros with formulas like

VALUES#children{status} = "In Progress"

I might be looking the completely wrong way, but I feel it should be possible somehow! Any help would be greatly appreciated.

[Marijn Plat · Accepted solution]

it looks like this issue https://community.atlassian.com/t5/Jira-Software-questions/Jira-Structure-Formula-to-display-child-s-status/qaq-p/1962654

[Stepan Kholodov _Tempo_]

Hello @Marijn Plat  

You can try either approach: 

1.If in your structure, issues of Epics are present under their parent epics respectively, then the formula can look like this:
if issuetype = "epic": max#children{if search("step 1", summary) : status}

2. If your structure only has Epics, then at this time it is not possible to extract any values of Issue of Epics with a formula. If this is what you need to do, please let me know if you want to be notified when it's possible - we have this feature in our backlog and we can post an update here when it's released.

Best regards,
Stepan Kholodov
Tempo

[Marijn Plat]

Thanks Stepan. I figured it out around the same time you typed your answer. Thanks for your time!