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.
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.