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.
3
questions
5
votes
2
answers
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 ...
- 81
4
votes
1
answer
19k
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 ...
Jordan Tuck
1
vote
1
answer
150
views
How do I conduct conditional data validation multiple times so that each input prompts a different conditional validation outcome
I am a member of a project that does electricity monitoring, and I am trying to organize our contact sheet to indicate the status of our electricity monitoring across locations. I want to make the ...
- 11