Help

How to create an automatic "depended on by" column in a gantt?

Topic Labels: Views
2699 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Zoe_Mesirow
4 - Data Explorer
4 - Data Explorer

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?

3 Replies 3
David_Shenoda
4 - Data Explorer
4 - Data Explorer

Im also really interested in this. Seems like it should be really easy!

Dont suppose you found a way?

Ben_H
6 - Interface Innovator
6 - Interface Innovator

Maybe a roll up field?

Paul_Warren
8 - Airtable Astronomer
8 - Airtable Astronomer

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!