How to create a formula column with specific linked issue?

Question

Hello,

I created a structure to list all epics of specific components and their issues. I would like to add 2 columns to display:

* the last Sprint each story was in:
I tried with a formula on "sprint" field with no succeed, I can only get the full list or the first one using SEARCH function. Maybe using a regex it can be possible?
* a link to a ticket part of linked issues of each epic:
It's a ticket with an issueKey like "CAN-0000", we only have one. I could display "Linked Issues" but our have many links, I would like to use a formula instead to display only the link to this "CAN-0000" ticket. Jira displays an error saying "linkedIssues" does not exist.

Can you help me with these S-JQL queries? Thanks :)

Gonchik Tsymzhitov · Answer

Hi @Stepan Kholodov _ALM Works_ ,

do you have any plans for now :)

Looks like it's awesome request

Cheers,

Gonchik Tsymzhitov

Stepan Kholodov _ALM Works_ · Answer

Hello Sébastien,

I'm afraid the described is not possible in a straightforward way - the Formula column doesn't have access to the history of issues being assigned to different Sprints, so it can't know which one of the existing Sprints is the last one. But if there is a pattern in Sprint naming and the last Sprint can be distinguished by the highest number, for example, then potentially there can be some solution. But we would need to take a look at your set-up in more detail for any further recommendations.

As for showing a specific issue in a column - you can use the Formula column for showing issuekeys of sub-issues, linked with a particular link type. But if you specifically need to have a clickable link, then only the Linked Issues column supports links and at this time it is not possible to configure it to show anything other than all linked issues. We have an improvement in our backlog for allowing to select link types of issues to display there, so if it sounds useful to you, please let me know and we'll add you to the notification list of this feature.

I hope this helps. If you need further assistance, please contact us directly at support.almworks.com

Best regards,
Stepan Kholodov
ALM Works