Linking Multiple Form Responses Into a Single Spreadsheet

[JPARKBM]

I have multiple forms that I would like to populate a single
spreadsheet. My forms have different questions that go out to
different users. I would like to monitor answers in a single
spreadsheet that has multiple tabs. I would also like to use some
Charts that utilize data across all of the forms.

Is there a way to set this up?

Thanks in advance,

Justin

[Jeff Giasson]

Justin,

Yes, this is possible using formulas. The trick is to use the
"ImportRange" formula and the spreadsheet key. Here is how to
accomplish this:

For each column, use this function in the first row and include all
potential rows that will be filled with data.
=importRange(spreadsheet-key, range)

"spreadsheet-key"= Key of Spreadsheet you would like to pull data.
"range" = sheet and range (example "Sheet1!B10", or "B1:B75")

E.g. the spreadsheet URL (in the URL bar atop the spreadsheet) is:
https://spreadsheets.google.com/ccc?key=0AqhqY231XZd3cFBiY2VqeWdmNWdhaDBqTnNxVi1sVlE&hl=en
The part after "key=" and before the
"&" ( 0AqhqY231XZd3cFBiY2VqeWdmNWdhaDBqTnNxVi1sVlE ) is the key.

An ImportRange function call would look like this:
=ImportRange ( "0AqhqY231XZd3cFBiY2VqeWdmNWdhaDBqTnNxVi1sVlE" ;
"B1:B75" )

See this post for more information:
http://www.google.com/support/forum/p/Google+Docs/thread?tid=3d7d21958b767a08&hl=en

Using this formula, you can create a spreadsheet with multiple tabs
and pull each column from each sheet as you wish. This will update
live as the form is updated. After this is complete, you can setup a
Chart that can utilize data across each of these tabs. Here is a
useful tutorial on creating charts: http://www.youtube.com/watch?v=t9-ysq1640Q.

Good Luck,

Jeff