You could make the second validation list an if/then statement dependent on the answer to the first one.
An example is here.
You have not mentioned what you would like to so with the three values mentioned, but maybe try:
I adapted user0's answer to have the following additional features:
It works in a multi-worksheet spreadsheet by specifying which sheet the change will occur in, as opposed to making the same change in every sheet.
It only sets the date if the checkbox is checked (i.e., its value is set to TRUE).
I got rid of the date formatting so that it will retain the ...
I have a cell with a check box. I want another cell which contains a
date to go green when the tick box is checked.
You go to Format, Conditional Formatting and use the Custom formula:
On the other hand, if you want the whole range/column to be highlighted use the following formula:
From Extend Google Docs, Sheets, and Forms with Apps Script - Docs editors Help
If you’d like to learn Apps Script but you’re new to programming,
(Note that this course was not developed by and is not associated with
Google.) Once you feel like you have a handle on ...
Use =vlookup. Say your names are in ColumnA of Sheet1, with corresponding details in ColumnsB:C. In a different sheet ColumnD (assumed to be where the validation takes place) with names can be matched with the corresponding details with a formula such as:
copied across to the right (with 2 there changed to 3) and then ...
Yes, with data validation:
Eg Select ColumnB of Kids, Data (top right in image), Validation..., Cell range: Kids!B:B, Critera: List from a range Parents!A:A, select from options, Save.
This should fill the range with the grey down arrows and when clicking one of these a dropdown list such as that shown should appear.
If you were able to separate the ...
In contrary to Short text, paragraph and checkbox questions, Google Forms doesn't have a way to validate input through date questions. Ref. Set rules for your form
There is no way to add client-side code to the respondent view of Google Forms but you could create a web form that submit form data to the Google Form back-end.
Some "early" approaches copy the ...
This used not to be possible, and I suspect still isn't. A workaround of sorts may be to enter:
in a spare area, and then apply whatever range that occupies to the list range for your dropdown.
Custom formula type of data validation is evaluated independently of the cell. In other words, I was assuming that it was checking if the value returned by the expression was equal to the current cell. In reality, it was checking to see if =eomonth(A169,-1)+1 equaled "true" (or -1, I suppose).
There are 2 potential solutions here.
Maintain "Custom ...