Thursday, July 19, 2012

yogi_Make Computed Column For Order Cost From Item Prices Google Form Questions

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #641   Jul 19, 2012

user Kelemvor said:(!category-topic/docs/spreadsheets/UuSHv00N_5g)
Can I make a form and have the spreadsheet do math on the entries?
So I'm trying to put together a basic order form.  I have a spreadsheet that has items going across the top.  Each item has a price.
I want to make a form that will list the items and people can enter how many of the items they want to buy.
When they submit it, the data should go into the spreadsheet and calculate a total.
I tried having a header row with items and a cost row below that, but the form entries went above the cost row and moved everything down so it didn't work.
Here's a link to the spreadsheet which has a simple form attached.
Any help would be great.

following is a solution to the problem ... I have added some more data and a sheet for extracting orders by name of order placer