How to index using more than one row_index

So I am working on making a list of the successors assignees, so that smartsheet can notify people once the predecessor tasks have been done, I have pulled the list of successors using the formula =JOIN(SUCCESSORS([Task Name]@row), ", ")

and to find the corresponding person to that row I use

=INDEX([Assigned To]:[Assigned To], VALUE(Successors@row))

but this only returns one person's contact, how can I make this in a way to return more than one contact in the same cell?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!