Solved

# Google form and google sheet

Posted on 2010-11-19

Hi Experts,

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.

Thanks,

v70