Use Google Apps Script to create Google Sheets sort-by-color and filter-by-color features and replicate the functionality that Excel has.
Love the clever workaround Ben Collins uses to let you filter and/or sort a Google Sheet by cell colour. Ben’s post includes all the code you need and an explanation of how it works … or you can just make a copy of the sheet and start using yourself.
Source: Google Sheets Sort By Color And Google Sheets Filter By Color, With Apps Script
Google Sheets expert Ben Collins shares tips and tricks for getting the most out of G Suite for your personal or business email.
In this interview Ben also shares a number of Google Apps Script based solutions he has developed and shared for managing his inbox including “I wrote a small program that automatically creates a draft reply from each row of my Google Sheet. Based on the sentiment of the response, the program adds a generic thank you message. Now my workflow is to go directly to my draft Gmail folder, review these draft emails (which include the feedback so I don’t even have to look at the Google Sheet) and add a custom response before hitting send”. You can view the interview for a link to the example script Ben shared for this.
Source: How I Email: Ben Collins, Google Sheets Developer & Data Analytics Instructor – The Gmail Genius
Learn how to use Goal Seek in Google Sheets. The Goal Seek feature enables you to change input values to make a formula result match the goal you specify.
We’ve highlighted the new Goal Seek Add-on previous in Pulse, but if you missed it or wanted to see some more practical use cases Ben Collins has expertly covered how to setup and use it.
Source: Goal Seek in Google Sheets – How To Use Goal Seek In Google Sheets