I would like to use validation "List from a range" in all the cells of column B only if in the correspondent cell in column A there is data in it.

Is there a way to do it?


List from a range option of data validation doesn't work that way. You could try to use a custom formula, but this option doesn't show a dropdown.

  • do you think that can be possible with Google Script instead? – Kintaro Jan 10 '17 at 9:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.