Can you filter drop down responses in a column based on the answer in a previous column?
I am working on a scheduling system and I have Primary and secondary locations. I used Drop down menus to organize the data in the primary location and secondary location columns. Can you set up a filter for the possible responses in the secondary location column based on the response selected in the primary column?
Primary location column lists areas A, B, C, D, E, and F in the drop-down menu. The secondary location list subareas 1 - 100. If areas 1-10 are only available in A. If I select A in the primary location column can I set up a condition that limits the responses to 1-10?