Canned Response Filter

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.

Canned Responses Filter Animation

Continue reading Canned Response Filter

FILTER Formula in Google Sheets

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%).

Filter Formula (Google Sheets) Animation