Recursion for total quantities in bill of materials

[Rickard_Abraham]

A recursive structure without custom parameterized formulas is a little tricky, but doable I’d say!

For simple recursion without parameters I got a little experiment here

And one for infinite recursion, you can also see that the values column has become some sort of “memory” column, but that the infinite loop is broken after around 14 steps when updated.

The issue in this post though is that values need to be brought with every recursion, aka parameters. I got a working solution in my personal doc for the game Satisfactory!

Here I solve the parameterization by making each button one recursion step which allows me to bring parameters in the form of cells. Then there’s just a help button to click the button as many times as needed (green button (it doesn’t matter which row you click the red or green button on, they’re just shortcuts))

I bet you could make cleaner recursion with a custom pack (albeit slower)