Hello Guys,
I am struggling over a week to find a solution to my problem. I am trying to create a multi-dependent dropdown list(through data validation). My data contains 3 rows of names. The names are in a "relation" such that I would like to pick first name, then in the second dropdown i would like to pick only from those names that are "connected" to the first one and in the last one pick the name "connected" to the second one. So far, i was only able to create dropdowns that lists all the names, but not "connecting" in a way i want them to be.
Do you guys have any idea about how i can deal with this problem?
Thanks in advance!test.PNG