Tuesday, September 15, 2015

Tech Tip Tuesday: Formatting Responses from Forms

When you create a Google Form, a response sheet is automatically created with a record of all of the responses from the form.  This response sheet is a spreadsheet. 

However, if one of the responses is a long response, this will cause the data to overlap in the columns next to it, making it difficult to read the data.  You can apply formatting features to the cell, but the formatting does not remain when a new response is added to the sheet.  See the image below.  

In order to keep the formatting for all new responses in the sheet you must perform the following:

  • Go into the Response Sheet.
  • Add another sheet by hitting the plus sign at the bottom of the screen.  A new sheet will be created and named Sheet2.
  • Click on the Sheet2 tab.
  • Go to cell A1, and type the following:  =QUERY('Form Responses 1'!A:K,"Select *",1)
    • A and K are the columns in the sheet
  • Format your column accordingly
  • Now submit another entry into your form and the cells will keep their formatting features.

Note:  The form responses 1 sheet will have the entries in the original format.  The Sheet2 sheet will have the entries in a formatted state.

No comments:

Post a Comment