Successor Column
Hi Brain Trust
We have a sheet using predecessors and have just been ask if we could have a Sucesor column -
iIt would be good to know when amending a date what other items are dependent on that date
Answers
-
You have add a Successor column and have a formula in there if you already have a Row ID column. Your formula would be
=JOIN(COLLECT([Row ID]:[Row ID], Predecessors:Predecessors, [Row ID]@row), ", ")
This will populate the rows which are directly marked as a Predecessor for each row.
Here's how the results would look like
You can change the collect to populate the name of the task instead by changing Row ID to Task Name in the above formula.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
Formula
=JOIN(COLLECT([Task Name]:[Task Name], Predecessors:Predecessors, [Task Name]@row), ", ")
But it isnt returning Anything
=JOIN(COLLECT(Row:Row, Predecessors:Predecessors, Row@row), ", ") is working and will return ROW ID
-
Try this formula
=JOIN(COLLECT([Task Name]:[Task Name], Predecessors:Predecessors, [Row]@row), ", ")
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 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!