Dependent drop down list

AppSheet AppSheet Q&A
1

Hi,

I’m working on creating a dropdown list in one table that is dependent on another table containing employee information.

Jacek1_2-1702215946659.png
Jacek1_2-1702215946659.png535×286 12.3 KB

In the second table, I’d like to implement a dropdown list that dynamically populates with active employees based on the team selected in the respective row. For instance, if I choose “Team A,” I want the dropdown to display options such as Jane and Joe for selection (not Daniel as he is inactive).

Any help will be apprecieted.

2

Try something like SELECT(Employees[Employee],AND([Team]=[_THISROW].[Team],[Status]=“Active”))