Return a task name that corresponds to the row in the predecessor column
Hi there -
I'm trying to get the text of the Task Name to show up in a column called "Pre-Reqs" that corresponds to the row number in the Predecessor column. I created a Row ID column, bc there's no easy way to reference rows. I've tried lookup and if statements and can't get it to work. Please help!
Answers
-
This is the closest I've gotten, but do I have to do this for every ROW? That seems impossible.... or nearly. There has to be a better way!
=IF(Predecessors@row = "10", [Task Name]10)
-
Here is a thread with some notes on the SUCCESSORS function.
-
Hi Paul -
Thanks for the reply, though unfortunately this doesn't seem to quite answer my question...
I want to share the TEXT of the TASK that is the row of the predecessor. IE I have a task that is linked by the predecessor column. That column says 10. I'd like another column to share, automatically, the text based on the cell that says the preceding task is row 10. So I can easily know the tasks I need to get done before I can start on this particular task. Does that make sense?
If your solution works for that and I'm not picking it up, please share any more insight you may have.
Thanks!!
-
Apologies. I just posted this update in that thread to try to keep everything together:
"To pull the task name(s) of the actual predecessors, we would use the above instructions on generating the row number on the sheet. Next we would insert a multi-select dropdown column and enter
=SUBSTITUTE(Predecessors@row, ", ", CHAR(10))
Doing this allows us to "parse" those predecessors out into individual numbers as opposed to a text string. Finally we would use formula such as this to pull a listing of all of the predecessors:
=JOIN(COLLECT([Task Name]:[Task Name], Row:Row, HAS(Pred@row, @cell)), CHAR(10))"
-
I got #UNPARSEABLE error. How do I fix this?
-
@NQUIN Exactly what is the formula you are using that is throwing the error?
-
@NQUIN were you able to solve getting the predecessor name to display in another column?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!