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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!