I am currently maintaining an action/deliverables register with approximately 500 line items.
Each line item has a corresponding unique action ID code (e.g. AE11.02.01), which contains useful information regarding the relevant business area and related topic.
Currently any dependencies are listed by row number and is only visible on the main sheet.
I'm seeking to create a column whereby, based on the predecessor row numbers, it will list the unique action ID codes instead of just the row numbers. This column could then be added to reports and dashboards.
Currently I can do it for actions with 1 predecessor, however as soon as there are multiple predecessor rows listed, the formula fails and doesn't show anything.