Forum Discussion
Multiple dropdowns using shared terms
Hi, I'm trying to create an interview form in Excel with multiple dropdowns. Essentially, if a certain role type is selected, I need the form to bring up a set of questions related to a particula...
The issue is that I can only have one group named "Accountability" to reference via indirect Data Validation. I realize that I can technically create variations of the group name "Accountability" for each role type, but I only want the end user to see the "Accountability" in the dropdown menu.