Is there a way to populate the successors names in a cell based on successors column?

sweta22

Hi there,

I am working with a sheet that includes a predecessors column. I have also created a successors column that lists the successors. I need to display the names of the dependent initiatives in another column. Currently, I am using the following formula, which works only when there is a single successor:

Dependent Initiatives: =JOIN(COLLECT([Initiative Name Input]:[Initiative Name Input], [Row ID]:[Row ID], HAS(Successors@row, @cell)), CHAR(10))

Successors: =JOIN(SUCCESSORS(Predecessors@row), CHAR(10))

I need the names of all the successors in the cell. Can someone help me with this? Thanks in advance!

Darren Mullen

@sweta22 Yes you can do that!

I went ahead and made a video to answer you question. Let me know if that works for you!

https://youtu.be/s5lGI0pxpMQ