If you do not want to create a new "form responses", make a copy of the forms (Not the response sheet). In the copied form, Change the response sheet to the one with all the formatting by going to:Menu>Responses> Change responses destination
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.
Best Answer
It is NOT recommented to work on the responce sheet itself.
Step 1
Form responses 1
being the first one, on a second sheet (eg.Master
) create a "live" copy of the existing -and future- data usingimportrange
or a query or .....You can read more about available functions on the official help page
Examples:
Step 2
On a third sheet (eg.
Calculations
) do all the alterations you need keeping all original data intact.