Notification

Bring your best ideas to life with Gemini for Google Workspace. Get tips & real-life use cases for using gen AI at work.

Switch from Excel to Sheets

Get Sheets productivity tips


               

Want advanced Google Workspace features for your business?

Try Google Workspace today!

 

 

On this page

Import data from Forms

Analyze data from Google Forms by sending it to Sheets.

  1. In Forms, open the form with the data you want to import.
  2. At the top, click Responses.
  3. Click Moreand thenSelect response destination.
  4. Create a new spreadsheet or select an existing one.
  5. Click Create or Select.

Select response destination.

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:

  1. Open Sheets and at the top, click Template Gallery.
  2. Click the template you want to open it.

Create your own template:

  1. Open Sheets and at the top, click Template Gallery.
  2. At the top of the gallery, click your organization’s name.
  3. Click Submit Template.
  4. Click Select a spreadsheet, and choose the template file you created, and then click Open.
  5. Select a category for your file.
  6. Click Submit.

Your new template appears in the Template Gallery under your organization’s name.

Sheets template gallery.

Find out if someone changes a spreadsheet

Notification rules let you know when any changes are made to a spreadsheet.

Sheets: Create notification rules:

  1. In Sheets, open the spreadsheet where you want to set notifications.
  2. Click Tools and then Notification rules.
  3. Select when and how you want to receive notifications.
  4. Click Save.

In a sheet, find the "Notification rules" option in the menu under "Tools".

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:

  1. In your spreadsheet, select the cells where you want to add checkboxes.
  2. Click Insertand thenCheckbox.

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.

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.

In Sheets, open the Checkbox option by clicking Insert from the menu.
 

Back to top


Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.

Was this helpful?

How can we improve it?
Search
Clear search
Close search
Google apps
Main menu