- Local time
- Today, 22:08
- Joined
- Jul 9, 2003
- Messages
- 16,273
This is a nice example of using Google forms together with a Google sheet. Also Demonstrated is an "Array Function" Which can replace the need for having a formula for each row. For example you may have situation where a function in Column "C" Adds the value in column "A" to the adjacent value in column "B" and places the "SUM" in column "C" a formula in Each Cell of "C". This Video shows you how to produce an "Array Function" which does the calculation of all the values in ONE GO! Very useful and alludes to a technique I have yet to understand.
Google Forms - Formulas in Sheets That Autofill with Submit
Google Forms - Formulas in Sheets That Autofill with Submit