How can I set the dropdown list in a cell to change when an item is selected from the first dropdown list in Google Docs Sheets?

Question

Google

Colleagues, good afternoon.
I ask for expert help with the question:
I have a drop-down list of certain elements in one column in a cell in Google Docs in a table, and when one of the three elements is selected, the required drop-down list should automatically be pulled up in the second column in the cell (there are also three of them).

Answer 1

I just recently solved it like this)
(I did support for two language interfaces)
Created a drop-down list on the charlist page in cell B1: Russian, English
On another sheet (language) set two columns one with Russian value. Another corresponding English
For example:
gnome / gnom
Orc / Orc
Man / human
On another sheet, I created a line in which the language is checked by if and thereby selects the desired value. (race or race, etc.)
Next, I named this line with the races as the race range
And created a drop-down list with the race range.
Result: When you select a language, the drop-down lists dependent on it change as well.
In the case of 3 options, 2 ifs are needed. And another column

IF(Charlist!$B$1="English";language!$B9;IF(Charlist!$B$1="français";language!$С9;language!$A9))

Answer 2

This is a good option if you have up to 3 languages. I have a similar problem now, and in the first list of 7 options, I think writing if 7 times is not at all sporty. We need to find another way!

Answer 3

Tell me, did you solve the problem? I have the same problem and I can't seem to make the drop down list. If you share your advice I will be very grateful!

Answer 4

https://www.youtube.com/watch?v=YfVQ_udH7O4