In this section:
|
8.1 Import data from Forms
Analyse data from Google Forms by sending it to Sheets.
- In Forms, open the form with the data that you want to import.
- At the top, click Responses.
- Click MoreSelect response destination.
- Create a new spreadsheet or select an existing one.
- Click Create or Select.
8.2 Save time with templates
If you’re creating the same types of files over and over, such as expense reports and purchase orders, save time with a template.
Sheets: Choose an existing template:
- Open Sheets and, at the top, click Template gallery.
- Click the template that you want to open it.
Create your own template:
- Open Sheets and, at the top, click Template gallery.
- At the top of the gallery, click your organisation’s name.
- Click Submit template.
- Click Select a spreadsheet, and choose the template file that you created, and then click Open.
- Select a category for your file.
- Click Submit.
Your new template appears in the template gallery under your organisation’s name.
8.3 Find out if someone changes a spreadsheet
Notification rules let you know when any changes are made to a spreadsheet.
Sheets: Create notification rules:
- In Sheets, open the spreadsheet where you want to set notifications.
- Click Tools Notification rules.
- Select when and how you want to receive notifications.
- Click Save.
8.4 Add tick boxes to cells
Use tick boxes to make Sheets more interactive. You can use tick boxes with charts, filters, pivot tables and formulas.
Sheets: Add or remove tick boxes:
- In Sheets, open a spreadsheet and select the cells where you want tick boxes.
- Click InsertTick box.
- (Optional) To delete tick boxes, select the tick boxes that you want to remove and press Delete.
Note: In formulas, unselected tick boxes have a value of FALSE (exclude) and selected tick boxes have a value of TRUE (include). You can see the value in the formula bar. You can also change this value.