Select with 2 Condition for dropdown

AppSheet AppSheet Q&A
,
1

i’m try to get data in depend drop down but i need to filter the conditions

ANY(
AND(SELECT(Room_Data[ID_Room], ([_THISROW].[Room Type] = [Room_Type])),FILTER(“Room_Data”, [Status] = “VC”))
)

2

FILTER(“Room_Data”, AND([Room_Type]=[_THISROW].[Room_Type], [Status]=“VC”))

Some typos corrected..

1 Like
3

Thanks for the solutions