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!


  • 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)

  • 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.


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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))"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!