SheetWorkflow Guide 
Keep Google Sheets Status Entries Consistent with Dropdowns
A dropdown presents a defined set of values, reducing inconsistent entries such as different spellings of the same progress status.
Use FILTER When a Separate Result Table Is More Useful
The FILTER function produces matching data at the location of the formula, while leaving the original range in place.
Filter Google Sheets Records by Their Existing Colors
Google Sheets can filter by fill color or text color, whether the appearance was added manually or through conditional formatting.
Choose Clear Conditions for a Google Sheets Filter
The source describes using the toolbar's Create a filter control to add filter buttons to column headers.
Check the Range Before Filtering a Shared Google Sheet
A filter temporarily hides rows that are outside the selected criteria; it does not remove the underlying records.
Use Filter Views Without Changing a Collaborator's Display
An ordinary filter can change how other collaborators see a shared sheet.
Choose Basic Sharing Roles for a Google Spreadsheet
The Share control in Google Sheets lets an owner invite people and decide whether they should view, comment on, or edit the file.
Give a Plain Google Sheets Range a Useful Table Structure
A plain range of names, values, and dates can be difficult to analyze or share.
Build a First Google Sheets Formula in the Result Cell
In Google Sheets, select the cell where the answer belongs, type an equals sign, and add the function name.
Learn How Google Sheets References Behave When Copied
A formula begins with an equals sign, followed by the expressions or functions needed for the result.
