I have my cashflow forecast on Smartsheet, and i have a formula which looks at the balance on the row above to apply the balance for the current row as follows =BALANCE1350 + [in's]1351 - [out's]@row.
When i shift the row up or down within the sheet, it keeps looking the the balance original balance on the row that was above it, not the new row above. (see screenshot example)
Is there any way i can get it to automatically look at the balance on the new row above?
i know how to use @row for a formula to look at something on the same row, but not the row above.
Also is there a way to get the formula to be automatically added to new rows inserted in-between existing rows (not at the bottom or top of the sheet)?