I'm trying to create a spreadsheet where the choices in the dropdown menu A dictate the choices in dropdown menu B. For example:
If in menu A I choose "Onsite Meeting" my choices in menu B are "Onsite Option A", "Onsite Option B", "Onsite Option C", etc...
But if in menu A I choose "Development Week" my choices in menu B are "Development Week Option A", "Development Week Option B", "Development Week Option C", etc...
Attached is a simplified version. Menu A is in column A and activities would be in column B. The data validation lists are under "Dropdowns" tab.
Thanks in advance!
Bookmarks