how to I script a recursive function to a sum column that uses itself and a neighboring column. I attached an example... Col 2 in this example would be the one that needs a recursive-type formula. Thank you for your help. Christa
You can get close, like this. The if statement in the formula deals with the lag(formulaCol) getting started without a cascade of missing values.