validationgoogle-sheetsfilterdropdowngoogle-sheets-formula
Filtering dropdown list in Google Sheets based on a checkbox on another sheet
this seems like a very simple thing to do, but I've not been able to find an answer (probably because I'm not using the right words to search).
What I'm trying to do is create a dropdown list that only includes names if certain criteria are met.
I have a registration list of names on Sheet 1 Column C, with a checkbox in Sheet 1 Column E that needs to be checked once ID has been validated. On Sheet 2, I want to create a dropdown list in column C that only includes names from Sheet 1 Column C IF the Sheet 1 Column D checkbox is checked.
Solution
use helper column to create items for dropdown validation. in Z1 of Sheet2 paste:
=FILTER(Sheet1!C:C; Sheet1!E:E=TRUE)
then create dropdown from list of items located in Z column. when you done you can hide Z column and forget it.
- How can I validate multiple action parameters with ValidationAttribute in ASP.NET Core 3.0
- What is a regular expression which will match a valid domain name without a subdomain?
- How to best validate JSON on the server-side
- Nested Object Yup and Form Primevue
- validate the credit card expiry date using java?
- Xcode 4.4.1 Error Validating Mac app : CFBundleExecutable of two bundles may not point to the same file
- How to allow only English letters in input fields?
- validate nested objects using class-validator in nest.js controller
- Are PDF headers all the same regardless of version
- Custom Rails Validation (Doesn't seem to be working)
- How to set focus to a control after validation in .NET
- Laravel validator and excel files error
- See if a string contains any characters in it
- Improving the below RegEx for US and UK Names
- How to allow only numeric (0-9) in HTML inputbox using jQuery?
- Pydantic Validation error: Input should be a valid dictionary or instance
- Convert numeric words embedded in strings into their integer equivalent, then validate the mutated strings
- How can I check if a value exists in multiple arrays where keys are the same
- Check if a 2d array contains a row with a particular column value
- Check if a value exists in an array of arrays
- Force validation on bound controls in WPF
- Laravel update model with unique validation rule for attribute
- how we implement dto validation in nestjs TCP microservice
- Spoof-proof file type validation in a Spring Boot app
- Django 5.1 - UserCreationForm won't allow empty passwords
- Can I mark a field invalid from javascript?
- How do I convert a string to a valid variable name in Python?
- Symfony how to validate an EmailType by not allowing emails without an ending dot something
- Reset/remove a border in Swing
- Validated a lazy load component when auto filling it with data