How to make a choice component dependent on another choice component? I have 2 sheets in the workbook, Employees Sheet contains ‘Department’ and ‘Name’, Report Sheet contains ‘Date’, ‘Department’, ‘Name’, ‘OT Hours’. I want to create 2 choices components here, 1st one to get unique options from ‘Department’ and 2nd is based on that Department give me the list of Employees under that particular department.
Hey,
In the second drop-down field via “Options” you simply place a filter on the values to be selected in the second drop-down field: in this case the department would be your filter and the value displayed would be the employees in these departments.
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.