Smartsheet Product Feedback & Ideas

Smartsheet Product Feedback & Ideas

Help shape the future of Smartsheet! Share your feature wishlist and improvement requests here.

Sign in to submit new ideas and vote
Get Started

Listing dependencies by action number

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.

1
1 votes

Idea Submitted · Last Updated

Trending Ideas