I’m trying to make an aggregate of data in a table and wondering what might be a good strategy. I am trying to build a table of tasks and their “effort”. some tasks are associated with other tasks. How would I go about doing this?
My initial thought was to create a linked field called “predecessor”, rollup the effort field, and then sum in with the effort for the current task. This works fine for current task and 1 predecessor, but won’t go beyond that. I thought about doing a rollup of the rollups, but that led to circular referencing.
Is there a formula I’m missing to make this work?