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

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.