Two Different Dependant Drop with the same expresion

AppSheet AppSheet Q&A
,
1

Hi, I have an isue that I can’t solve

I need to do a dependant dropdown wich use the same information, but I need that the third iteration kind of start over.

In other words, two separate drops down with the same expresion.

Yeyo1976_0-1721109890034.png
Yeyo1976_0-1721109890034.png355×443 13.9 KB

Yeyo1976_1-1721109933764.png
Yeyo1976_1-1721109933764.png338×268 6.86 KB

First, you choose between 2 kind of Terapia Necesaria (Pic 1 and 2).

Then, shows only the Terapeuta that fullfill the selection.

Yeyo1976_2-1721110059467.png
Yeyo1976_2-1721110059467.png338×268 7.9 KB

Then I need to choose the second Terapia (Terapia Necesaria 2), but continues with data from the “list” above and shows only the same type of Terapia that I choose before, and the 2 active Terapeutas.

Yeyo1976_4-1721110354745.png
Yeyo1976_4-1721110354745.png338×251 7.65 KB

In Terapia Necesaria and Terapia Necesaria I use this expresion: Terapeutas Activas[Tipo Terapias]

In Terapeuta and Terapeuta 2 I use this: Terapeutas Activas[Nombre Terapeuta]

Both in Valid_if

Also I read this tutorial from Google (https://support.google.com/appsheet/answer/10106620?hl=es-US) but I don’t know how I may use Select(Terapeutas Activas[Nombre Terapeuta],true) or Select(Terapeutas Activas[Tipo Terapias],true)

2

You need to use SELECT() expression with the Valid_If to have your own dependence. Something like.. SELECT(Table[ColumnB],[ColumnA]=[_THISROW].[ColumnA])