Require formula for getting the predecessors argo-ids in one row when there is multiple dependency

Nagu

Hi Team,

please help on this to get the formula in smartsheet, it worked when there is a one predecessor for

=INDEX([Issue Key]:[Issue Key], [Predecessor Numeric]@row)

but it didn't worked for multiple predecessors.

thank you

Find more posts tagged with

Accepted answers

All comments

ECarlson_PCG

This post references creating formulas related to multiple predecessors and sourcing additional data in a new column(s). You do need multiple helper columns for each predecessor reference in a row.

To get to the formulas, here is the published sheet from the above post.

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.