Rollup of rollups?

Hi!
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?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.