I set up my table with a Predecessor field (linked field back to the table). I’ve been using this to drive some calculations on dates for sequencing and showing in the Gantt chart. However I want to also use the successor for some other calculations.
Here’s my question.
In the Gantt Chart view you can click on a record and it will show the predecessor and successor (if they exist). I have only set up Predecessors in my table. However for a record that is “in the middle” of a chain - the Gantt Chart view will show the predecessor (which I set) AND the successor (which it knows as that successor record is set as a predecessor for the record selected).
Is there a way (via a formula?) that I can access what the Successor record is? Clearly it’s available as it’s shown in the Gantt view but I can’t seem to determine it from a formula.
Thanks!