Forum Discussion
multiple dynamic drop down lists
Maybe I'm thinking too much into this, but could someone point me in the right direction? I have a file that's over 10 yrs old and needs some updating, needless to say it is beyond my ability and th...
I've gotten that, I just need the next (2nd & 3rd) dropdowns to be populated with the data from the first.
werner77 I think I get what you want but don't exactly understand because you say length and split or solid and then part number but I don't get why split/solid is a problem. In any case the secret to creating customized dropdowns dependent on prior selections is to use a helper column. Basically create a formula that will filter the data set(s) based on the prior selection and then have a dropdown based on that filtered list. In the attached I have length drop down and split/solid drop down and then the part number dropdown only shows part numbers that meet those 2 inputs. I hope this example helps.