Using Successors as a workaround for not having direct access to Row number

Sfisher

I'm giving Smartsheets and 2nd shot. Have been happy with use as a staff task tracker for last year and working on building a full project management system. I have used Predecessors to control status of next task unfortunately I have to manually enter a Task ID for all tasks matching the current row number as we still don't have access to the row ID in a cell. Hint, hint, everyone seems to want it. Using auto an auto number column doesn't work as new tasks could need to be entered into the middle of project organization. I've created a Successor column and function to populate the applicable row numbers but I'm hitting a wall at how to use them. I've tried suggestions from similar posts but I keep getting Unparseable. My end goal is to set up conditional formating to change all successor rows if the any predecessor has the Status of "Blocked"

DKazatsky2

Hi @Sfisher,

There is a way for you to add a column to track row id and it will update as rows are added/deleted. Us the following formula.

=MATCH([Task Name]@row, [Task Name]:[Task Name], 0)

Hope this helps,

Dave

DKazatsky2

Hi @Sfisher,

There is a way for you to add a column to track row id and it will update as rows are added/deleted. Us the following formula.

=MATCH([Task Name]@row, [Task Name]:[Task Name], 0)

Hope this helps,

Dave

Sfisher

It does, thank you. I don't fully understand what it is doing but it seems so simple and leads to curiosity of why so may threads about how to use the task ID number in a formula don't mention this solution. Having this number should help but I'll still be looking to it along with successors to push formats, etc. all the way down a task chain.