Google Sheets Query with Column Selection Checkboxes

This lesson illustrates how to create a Query in Google Sheets that allows the user to select different Columns in the Results based on "Checkbox Selections." To achieve this we have to create checkboxes on our spreadsheet with IF Functions in the cells to the left of these Checkbox cells. If the checkbox is "checked" or "true" then the IF statement reflects the column letter and a comma in the cell to the left. If "unchecked" or "false" then the IF Statement reflects an empty cell. Once the checkboxes and If statements are setup, it's just a matter of linking the cell values to our Select Query statement. Towards the end of the video I also mention how to deal with variable of the last column selection that can't have a "comma" on the end of it. There is an easy work-around solution to this problem. Learn more about Google Sheets Functions with this Book at Amazon. https://amzn.to/3HkHcGa Buy the complete Google Workspace User Guide at Amazon: https://amzn.to/3Hr9dLW DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links