I’m trying to create a “depended on by” column in a gantt that will automatically pull all of the tasks (text field) for which a given task is listed as a dependency (linked field). For example, if task 1 is listed as a dependency for 5 other tasks, I’d like this new field to automatically list those 5 tasks.
Does anyone know if this is possible/how to set this up?
I think you all may be happy to look at this thread: New Script: Same Table Linked Records Backlinks
@openside created a script to create these back links. It’s not a text field, but rather creates reverse links, which is even more useful. If you need a string, you could use a formula based on the reverse linked fields.
Also, at the end I describe a method of automating the script. Hope this helps!