2

I had a working Google Spreadsheet where when new responses were filled in on the form, they would automatically get textwrapped on the Form Responses sheet.

Now recently I had to remake this spreadsheet and I just can't seem to figure out how to do that, automatically that is.

I know about 'paint format' and the textwrap button itself but I need it to do that automatically so I don't have to keep manually doing it myself.

I read about QUERY and ARRAYFORMULA but I can't get it to work.

3

The only way I found to do this is with a script.

Step 1: Go to Tools > Script Editor and put the following code there:

function wrap(e) {
  e.range.setWrap(true);
}

Step 2: Still in Script Editor, go to Resources > Current project's triggers, and select from dropdowns "wrap", "From spreadsheet", "On form submit".

NOTE: If under Resources you have no current project triggers - create a new one - name it "wrap" - then proceed to choose "From Spreadsheet", "On Form Submit" and it will work as stated.

Step 3: You're done. Close the Script Editor. The new form submissions will be automatically wrapped in the spreadsheet.

  • This worked. Thank you very much! – Chloe Jan 10 '16 at 22:22
1

With updated AppScripts

Step 1: Go to Tools > Script Editor and put the following code there:

function wrap(e) {
  var range = e.range;
  range.setWrap(true);
}

Step 2: Still in Script Editor, go to Edit > Current project's triggers, and + Add Trigger, "wrap", "Head", "From spreadsheet", On open, > Save.

Step 3: You're done. Close the Script Editor. The new form submissions will be automatically wrapped in the spreadsheet.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.