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"
S. Fisher
Best Answer
-
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
Answers
-
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
-
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.
S. Fisher
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!