Formula

[LETICIAHELENA]

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 solution]

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