Complex formula for Jira data pack

I’m not sure this is even possible but here is the use case.
I have 2 Syncs set up
TeamA
TeamB

So my base table shows all combined tickets for TeamA and TeamB, and some of the cards are linked between the two teams (Relates to, Blocking, Is Blocked By, etc) so for example:

TeamA has a card (Story1) that is being blocked by a TeamB card (Story2)

In the TeamA Story1 row, I want to display who the TeamB Story2 assignee is.

Added complexity is that Story1 could potentially be blocked by TeamB Story2 Story3 and Story4, and each could have a different assignee.

I feel like that is relatively impossible but I wanted to throw it out to this community anyway.

It can all be achieved.

In the assignee column you have a formula such as Blocked.Assignee
The only issue is you wont know the assignee to which story. You could sort it and match/be same order how it shows up in blocked column.

Otherwise if you want the info e.g. Story 2 - Assignee Bob , then create a new column with that info and then reference it

Unfortunately the main issue is that I do need to know which assignee to which story.

:backhand_index_pointing_up:

Also, is there a way to account for a card being linked to 3 other cards?

What do you want to “account for”?
Like by priority or date ?
I’m not sure what significance/end result you are chasing or trying to achieve

Sure so there is the main card, and then there are 4 related stories that are blocking the main card from being completed. I want to show who the Assignee is for each of the 4 blocking cards.

  1. Create a new column . Name it “Detail”. Formula for this column is something like Concatenate([Title], “ - ”, [Assignee])

  2. Create another new column. Name it “Blocked Detail” or something similar.
    Formula for this column is something like Blocked Detail.Detail