Formula

Question

Hello how are you? I need create a formula with my ending balance to be my starting balance for the next day.

I already have the opening balance and ending balance column but the starting balance has to be updated daily based on the final balance of the previous day

jonwyp · Accepted Answer

Hi, have made a couple of assumptions in the below solution as not much information was provided.

Assuming you have input columns in the below format, you can simply use a multi-row formula tool to assign the ending value in the previous row to the starting value of the current row.

Sample Input

Sample tool configuration

Sample Output