Google Sheets is powerful software that allows you to organize data in the form of a spreadsheet. You can also use it to set up tasks for yourself or a group of people. With such a function, some kind of callback would be extremely useful.
With this guide, you'll learn how to include reminders in Google Sheets, along with some additional tips you might find useful.
Setting up reminders
This option is not part of the default software, but obtaining it is simple and free. To get the add-on:
- Go to G Suite Marketplace and search for Add reminders.
- Now press the Installer button.
Adding reminders will evaluate the spreadsheet and send you a reminder for each row. You just need to set the date and the add-on will automatically set the reminders. To set reminders:
- Open a new document in Google Sheets.
- Click on Modules complémentaires in the main menu.
- Click on Add reminders.
- Go to Set up/Edit reminders.
- Write tasks, dates, and email addresses in each column. The add-on will automatically fill in an empty spreadsheet, so you can just fill in the information yourself.
- Click on the Add a new reminder button.
You can now select one of these options.
This will only show columns with valid dates, so make sure everything is written correctly. If you change anything from the first line, you will need to restart the add-on.
You can click on the cell and a calendar will appear.
This will allow you to send a reminder before or after the set date. Simply select the option that suits you.
With this option you can select recipients.
- Notify Me – Selecting this option will add your email to the To bar. This will send you a return email confirming that the email was sent.
- Notify People In – Select this option then you can select the column with the emails to which an email will be sent. The first line will not be included.
- CC People In – This will insert the people into the CC of the email. Select the column with emails, as in the previous option.
Tapping on this option will open a new window.
Subject – Allows you to write the subject of your email reminders.
Add link to spreadsheet – This option will include the link to the spreadsheet in the email.
Email body – This option adds text to the main part of the email.
After selecting the desired options, click the Done button. A sidebar will appear, click Done again.
You can now close the spreadsheet. The add-on will perform checks every hour and send emails at the right time.
Other Google Sheet Tricks
There are plenty of tricks that can make your Google Sheets experience smoother and more enjoyable. Here are some of the most useful.
Send emails by commenting
You can email someone when you add a comment to Google Sheets. It's a great way to let people know that something new has been added to the spreadsheet.
You can send the email by typing @ followed by the recipient's email. The email will be sent when you enter the comment.
You can use filters to browse a group of cells that have a common trait. This allows you to quickly find information even if you have a bunch of data stored in the sheet.
- Click it All filter brewing methods button.
- Now click on the All filter brewing methods from the main row of the worksheet to choose the values you want to see.
- You also have the option to save filters. Just press Create a new filtered view by selecting the All filter brewing methods button.
If you have a large group of people working on a single spreadsheet, you can prevent certain information from changing. This will make errors less likely to occur.
You can block particular cells or entire columns.
- Select Range editing permissions.
- You can also configure it to show a warning when someone tries to edit the cell. Select the option that suits your needs.
Google Sheets does not forget
Google Sheets is a very complex software and there are many options that will help you work faster and more efficiently. Reminders, for example, can save your life.
Have you ever used the Google Sheets reminders feature? Did you find this helpful ? Tell us in the comments!