Using Successors as a workaround for not having direct access to Row number
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"
Help Article Resources
Check out the Formula Handbook template!