Change How Dependencies Appear? - Would rather see task title vs row number
My engineers and technical team(s) have requested a bounty list be created. Obviously setting up a dependency is easy enough; however, it would be be more useful to see the task name that the task is dependent upon instead of the row number. Is there a way to do this by changing a setting that I don't know about? Or would it be easier to do a formula which calls for that specific rows task name? If anyone has seen this done or has an example I would appreciate it.
Best Answer
-
This approach will work for tasks that have a single predecessor.
First your sheet needs to be able to detect the row number for each row. To enable:
- Add an system Auto number colum (e.g., "Auto")
- Add a Row column with the formula: =VALUE(MATCH(Auto@row, Auto:Auto, 0))
The add a column to return the name of the dependent task (e.g., "Dependent On") with the column formula that will look for the row number that matches the value in the predecessor column and then return the task name:
=IFERROR(INDEX(COLLECT([Primary Column]:[Primary Column], Row:Row, Predecessors@row), 1), ">1 Predecessor")
You will still need to enter predecessors as row numbers, but you can basically return a friendlier name for your engineers and technical teams to referenece.
I'm sure this could be adapted with more advanced formulas to account for more than one predecessor. Happy to help with additional refinement offline if needed.
Jessica Selano | Selano Consulting
jessica@selanoconsulting.com
Answers
-
This approach will work for tasks that have a single predecessor.
First your sheet needs to be able to detect the row number for each row. To enable:
- Add an system Auto number colum (e.g., "Auto")
- Add a Row column with the formula: =VALUE(MATCH(Auto@row, Auto:Auto, 0))
The add a column to return the name of the dependent task (e.g., "Dependent On") with the column formula that will look for the row number that matches the value in the predecessor column and then return the task name:
=IFERROR(INDEX(COLLECT([Primary Column]:[Primary Column], Row:Row, Predecessors@row), 1), ">1 Predecessor")
You will still need to enter predecessors as row numbers, but you can basically return a friendlier name for your engineers and technical teams to referenece.
I'm sure this could be adapted with more advanced formulas to account for more than one predecessor. Happy to help with additional refinement offline if needed.
Jessica Selano | Selano Consulting
jessica@selanoconsulting.com
-
This is perfect, thank you so much!
-
Coming back to say that this worked EXACTLY as I was picturing. Thank you so much Jessica!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives