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?

Thanks

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You would have to use the JOIN function, but...

As of right now there is no way to use a formula like this to populate multiple usable contacts in a single cell. It will be output as a text string and will not be a valid contact for automations.

TO alert people when it is time to start their task, you would need to check a box on rows where the predecessor has been completed.

ahmedso3da

I see, Thank you

Also, is there a way to hide the error "#CONTACT EXPECTED" ? I tried the IFERROR formula but it doesn't seem to work here.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.