google-sheetsfiltergoogle-sheets-formula
Data Validation google sheets partial match
I have a tab in Google sheets with vehicle data coming from a google form. I made another tab to filter these data using a data validation. The validations are Car 1, Car 2, Car 3, Truck 1, Truck 2, Truck 3. This works perfectly. I'd like to know if I can add "Car" to the list which would pull Car 1, Car 2 and Car 3 at the same time. Is it possible?
Solution
Use QUERY() function.
=QUERY(Sheet1!A:C,"where C contains '" & D1 &"'")
- How to set column to plain text format for every sheet?
- Exceeded maximum execution time when trying to create a matrix
- getLastRow but ignore column A and Logger assistance
- Google Sheets Query referencing a Dropdown selection
- Check if edited cell is in a specific range
- Simpler check if a cell was edited and a certain value inserted
- How to sum / aggregate the results of "Filter" function
- onEdit combine timestamp and username/email address not working
- Copy value from a cell to the rest of a colum
- How to count the number of rows that meet a boolean condition?
- Google Sheets - Difference of Two Columns With Duplicate Values
- Using Apps Script to automate sending multiple emails from a google sheet, each with a different specific pdf attachment stored in Google Drive
- How to enumerate categories with formula in Google Sheets
- Sorting Names from rows of one sheet to another
- Uncheck checkboxes in an array
- How to do Cumulative sum in Google Sheets with arrayformula()?
- Using Sheets.Spreadsheets.Values.update() Correctly
- How can I automatically set the current date and time when the checkbox is activated?
- Using arrayformula to add suffix, but would like to skip empty cells
- Coloring the searched word in Google Sheets
- copyTo using {contentsOnly:true} not working
- Email from script Sending as [object Object]
- Display averages of a column for past five months in Google Sheets
- Sending data from HTML form to Google Sheets
- Initiate a download
- Is this possible - Python script to fill a Google spreadsheet?
- Is there any way to automatically create installable triggers?
- Return Top value plus ties for each change in another Column value
- split() in google sheets changes to numeric
- Adding a condition to a MAP formula