In a separate post, I shared my love of Canned Responses in Gmail. What’s better than being able to save time by clicking on a “canned response” to send it out? Having your gmail do it for you! That’s right – if you always send the same response to messages containing the exact same phrase or from the exact same sender, then you can create a Filter that automatically replies with one of your canned responses. Super cool.
Tip: you may want to also select to archive the message, if you’d like it to also disappear from your inbox after the canned response is sent.
Step-by-step instructions are after the GIF.
Continue reading Canned Response Filter
You can filter using menu buttons and create filter buttons in Google Sheets, but sometimes it’s valuable to setup a FILTER formula. One such instance is shown in the GIF below: when you have a Sheet that contains data about many students across many grades or classes. Using a filter formula, you can create a tab for each class or grade. You can also create tabs for certain criteria (like lower scores that require follow-up).
=FILTER(range, condition1, [condition2, …])
Note from the formula above, that you can actually identify multiple criteria (such as Mr. Kotter’s students who scored below a 75%).