Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Rollup of rollups?

Topic Labels: Formulas
220 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