How to display in a formula column the number of open stories for an epic in structures?

[Costin Calisov]

Hi,

I want to display if an epic from structures has still open sub items, but without bringing the epic sub items in the structure itself.

[David Niro · Accepted solution]

Hello @Costin Calisov ,

You can use the epicStories item property reference combined with FILTER() to display a list of the issues under the Epic that are still open.  If you would prefer a count of the issues you can add SIZE() to the end of it.

epicStories.FILTER($.statuscategory != "DONE")

epicStories.FILTER($.statuscategory != "DONE").SIZE()

Hope this helps.

Best,
David

[Costin Calisov]

It almost work , 

I have to change it with 

epicStories.FILTER($.status != "DONE")

 somehow it does not see the statusCategory,

but it does the job, ty a lot

[Constantin Calisov]

Hi David,

we moved to Structures (Cloud), and epicStories item property is not available here. Is there another way, cloud version specific to accomplish the same thing?

[Stepan Kholodov _Tempo_]

hello @Constantin Calisov 

at this time, it's not possible - the Formula in Structure Cloud can't yet extract values of child issues. We have plans to implement such a function in the future.

Right now, you can either:
- extract values from parent issues using the parent function;
- extract either parent or child values when both issues are added to the structure, and they appear as a hierarchy. Then you can extract any field value using either the parent{} aggregate function or any other.

If you need assistance with Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Constantin Calisov]

Would be a nice feature, I'm looking forward for it. Thank you for quick answer.