Embedded Files
Welcome to Sheets Ahead, a Google Sheets centric page. Below are a collection of situations where Google Sheets has been used to solve a problem or automate a task. You will find explanations of various functions and formulas and their possible applications. Most of the topics will have screenshots, videos, and downloadable examples to guide you through.
USING GOOGLE APPS SCRIPT in SHEETS
USING GOOGLE APPS SCRIPT in SHEETS
Google Apps Script can help turn repetitive tasks into a button click, or better yet, an automatic trigger. Click below to create your own copy of Calendar and Folder Helper, a Google Sheet with a few basic functions built-in.
See all of your events on one sheet, edit events on another. Create new events and invite guests, then remove them at your whim!
Dig into your Google Drive and see the contents of each folder with links to the files. Use the custom menu to change the header font colour, size, and style.
Watch the video for a sheet-by-sheet guide on how to use your new Calendar and Folder Helper.
HOW TO USE COUNTIF AND COUNTIFS
HOW TO USE COUNTIF AND COUNTIFS
The Countif function allows you to count the number of times the criterion appears in the range. With the Countifs function, you are able to repeat the range and criterion arguments. Watch the video to learn more about the Countif and Countifs functions!
Click the button above to create a copy of Countifs Example workbook in your Google drive. Check our Countifs page for the functions and formulas discussed in the video.
Where'd it go? - Earnings and Spending Tracker
Where'd it go? - Earnings and Spending Tracker
Click the button below to create your own free copy of Where'd It Go? - Earnings and Spending Tracker in Google Sheets.
The tracker is designed to help people track their monthly and yearly earnings and expenses. Simply add your bank transactions and use the dropdown to categorize the transaction, the tracker will do the rest! Full instructions are included on the first page of workbook.
understanding the sumifs function
understanding the sumifs function
One of the main formulas behind 'Where'd It Go?' is a group of SUMIFS functions that gather the data from each of the bank account sheets. Click the button below to find out more about SUMIFS.
Using Match and Index Instead of vlookup
Using Match and Index Instead of vlookup
The VLookup function is a powerful tool, but it does have a limitation that can be frustrating. With VLookup, your results column must be to the right of your search column. You can use the Index and Match functions in place of VLookup and avoid this limitation.
While using two functions together can be confusing, combining Index and Match together is not. Please watch the video for a straight forward guide on how to use the Index and Match functions in the same formula.
Page updated
Google Sites
Report abuse