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

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!

Find more posts tagged with

Accepted answers

All comments

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

Rob Smodlaka

I had the same issue but I was able to catch one small detail that fixed it. Follow the steps in the video above but when you create the SucHelp column (dropdown with multiple values type), make sure that the spacing in the formula matches the highlight below - space between the first and second comma, and no space between the second and third. I had a space between the second and third comma and it only returned names for rows with single successors like you said. That is because in cases where there were multiple successors, my formula created one field with multiple successors separated by a comma instead of creating multiple fields separated by a space. I hope this helps, it worked for me.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.