Questions tagged [data-validation]

Use when the topic is the process of cleaning, correcting and filtering input to reach a state suitable for the operation of a program.

Filter by
Sorted by
Tagged with
3
votes
1answer
15k views

Data Validation with an IF formula

I've got a list of items that I want to include in a Drop Down. Using data validation, all I need to do is add the range and this works. However, the list has various types of data and I want to ...
4
votes
2answers
3k views

Dropdown list based on the result of another cell's dropdown

I want to populate a dropdown list based on a selection of another cell's dropdown list. Here is my spreadsheet. E.g., if the user does not make a choice from D20 dropdown menu, therefore F20 ...