Google-sheets – Google Sheets Cell Reference

I would suggest this if you are simply copying to a new sheet.

=query('Form Responses'!A:G, "SELECT * ")

Syntax QUERY(data, query, [headers])

The 'Form Responses'!A:G, is the data range of the source sheet that you would like to draw data from.

The "Select * ", is the query and will select everything within the range defined previously in the same order.

I did not know this when I first started using Query so I will share. If you want to select specific columns but reorder them plus leave other columns out, you can do this by getting specific with your SELECT

ie. You have Data in Columns A:F but you want to leave D and F out and put E before C in your new sheet, You can use this "SELECT A,B,E,C"

You can read more about it here its quite powerful.

You can format the new sheet to your hearts delight and it will always update when you enter new data. As long as you have data in the range you've defined in the query.

The syntax of your first formula is wrong.

1. Form Responses!COL1:A is not a valid reference. Hard to know what you are trying to do here. NOTES:

   1. Range references could have the form A1:B1, A1:B, A:B or 1:1 where A and B could be any column name while the first is the same column or it be always at the left of the second, also 1 could be any row number while the first is the same or it's on top the second.
   2. Using COL1:A as reference is converted to A1:COL where COL is the 26th column of the sheet.

2. 'column(12)' is not the proper way to reference a column in the select argument of QUERY. Use Col12 instead without apostrophes/single quote marks.