I'm trying to create a family budget using google forms. I though I would explore this avenue instead of writing an app for it... in hopes of it been easy but I'm having a little trouble.
I created a form that sames to an excel sheet the following data
DESCRIPTION | TYPE | EXPENSE | DEPOSIT
I added a column to the spreadsheet call BALANCE.
I will like to crate a formula that adds/subtracts the values inside either the EXPENSE OR DEPOSIT column to the BALANCE column.
I know how to do this by simply copying the formula from row to row. But I want the whole column to have this formula.
Another problem is the very first value that would have nothing to add/subtract to it since it will have a type that I labeled "Balance"
I hope I'm clear with this long long question.