Parse Out Number Values in Successor Column

I have found multiple threads on this but I can't seem to get any specific formula to work for me.

I have a column to Join Successors =JOIN(SUCCESSORS(Name@row), ",")

The highest number of Successors I have is 4 and I'm trying to parse them out into separate columns.

I have formulas that work for three but can't figure one out for 4 numbers.

here are the ones I have that work for 3:

Left number:

=IF(Successors@row <> "", IF(CONTAINS(",", Successors@row), VALUE(LEFT(Successors@row, FIND(",", Successors@row) - 1)), VALUE(Successors@row)))

Middle Number:

=IF(IF(CONTAINS(",", Successors@row), VALUE(MID(Successors@row, FIND(",", Successors@row), LEN(Successors@row) - FIND(",", Successors@row) - 1)), "") = 0, "", IF(CONTAINS(",", Successors@row), VALUE(MID(Successors@row, FIND(",", Successors@row), LEN(Successors@row) - FIND(",", Successors@row) - 1)), ""))

Right Number:

=IF(CONTAINS(",", Successors@row), VALUE(RIGHT(Successors@row, LEN(Successors@row) - (FIND(",", Successors@row, LEN(Successors@row) - FIND(",", Successors@row))))), "")

When I have 4 successor numbers, the two middle numbers blend together in the second formula.

Any changes to my formula or guidance would be so helpful. Thank you!

Find more posts tagged with

Formulas

Accepted answers

Leibel S

@Kelly Pratt

Instead of trying to parse them from your 'Successors' column, you can access them directly.

Use the below formula, just change the bolded number (for whichever successor number you want to bring back):

=IFERROR(INDEX(SUCCESSORS(Name@row), 1, 3 ), "")

All comments

Leibel S

@Kelly Pratt

Instead of trying to parse them from your 'Successors' column, you can access them directly.

Use the below formula, just change the bolded number (for whichever successor number you want to bring back):

=IFERROR(INDEX(SUCCESSORS(Name@row), 1, 3 ), "")

Kelly Pratt

@Leibel S - wow!!! Way to take something I overcomplicated and share a much easier more streamlined way. Thank you so much!!

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.