|
In this section:
|
8.1 Import data from Forms
Analyze data from Google Forms by sending it to Sheets.
- In Forms, open the form with the data you want to import.
- At the top, click Responses.
- Click More
Select 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 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 organization’s name.
- Click Submit Template.
- Click Select a spreadsheet, and choose the template file you created, and then click Open.
- Select a category for your file.
- Click Submit.
Your new template appears in the Template Gallery under your organization’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
- Select when and how you want to receive notifications.
- Click Save.
8.4 Add checkboxes to cells
Use checkboxes to make Sheets more interactive. You can use checkboxes with charts, filters, pivot tables, and formulas.
Sheets: Add or remove checkboxes:
- In Sheets, open a spreadsheet and select the cells where you want checkboxes.
- Click Insert
- (Optional) To delete checkboxes, select the checkboxes you want to remove and press Delete.
Note: In formulas, unselected checkboxes have a value of FALSE (exclude) and selected checkboxes have a value of TRUE (include). You can see the value in the Formula bar. You can also change this value.
Back to top