Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Rollup of rollups?

Topic Labels: Formulas
203 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

0 Replies 0