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

[Aleksey Didukh]

Hi, @Stepan Kholodov _Tempo_! 

Is there any updates with the way to get issues under epics in formula?  

[Stepan Kholodov _Tempo_]

Hi @Aleksey Didukh 
It's not yet possible in Structure Cloud. You can only extract values of Stories and show them for their Epic if Stories are added in the structure under the Epic. 

If you have other questions - please reach out to us directly at our support portal.

Best regards,
Stepan

[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!