Miscellaneous general questions and answers about Google Sheets.
Sheets Tutorials
Google Sheets tutorial: How to use to automatically create a new sheet with data from rows matching your query
Here are the instructions on how to automatically create separate sheets with data from rows matching your query. The sheet will be created using Google Apps Script and populated using Google Sheets’ FILTER function. This efficient approach ensures that any changes made to the main sheet’s data are automatically reflected in the individual sheets.
Google Sheets tutorial: How to change timezone of the Google Spreadsheet
When you change the time zone of a spreadsheet, it changes the spreadsheet’s default dates to be shown in your specified timezone. On your computer, open a spreadsheet in Google Sheets. Click File and then Settings. Under General, click the Time zone menu to change your settings. Click Save settings.
Google Sheets tutorial: Import the data from multiple Google Spreadsheets into the one
Some examples of how to parse cells using Google Sheets formulas and functions
Google Sheets tutorial: Create a mirror sheet in that updates automatically
Create a mirror sheet that automatically shows only rows where the “IS DONE” column equals “DONE,” keeping a clean view of completed tasks. You can do this with a simple FILTER formula in the same spreadsheet or use a Google Apps Script (with an optional time-driven trigger) to mirror data across different spreadsheets.
Google Sheets tutorial: How to create a new Google sheet (tab)
Some examples of how to parse cells using Google Sheets formulas and functions
Google Sheets tutorial: How to add cells with data using Google Sheets formulas and functions
Some examples of how to parse cells using Google Sheets formulas and functions
Google Sheets tutorial: How to hide columns in Google Sheets
This short note explains how to hide columns in Google Sheets
Google Sheets tutorial: How to save Google spreadsheet as a Excel spreadsheet or as a CSV file
How to export or save Google spreadsheet to a CSV file
Google Sheets tutorial: Using BYROW and LAMBDA functions
BYROW and LAMBDA are functions can perform complex calculations and transformations on data. This support note explains how.