Filter with a condition dependent on a list

[Laurent69]

Hi AppSheet Team,

My formula works but it is not really correct if the list (with select) is above 4 items
Do you have a solution for a fairer formula?

Thank you in advance for your answers

filter("Seances",and(
[ID_Customer]=[_THISROW].[ID_Customer],ISNOTBLANK([ID_Package])

,or
([ID_Package]=index(SELECT(care_Package[ID_Package],[id_care]=[_THISROW].[ID_care]),1)
,[ID_Package]=index(SELECT(care_Package[ID_Package],[id_care]=[_THISROW].[ID_care]),2)
,[ID_Package]=index(SELECT(care_Package[ID_Package],[id_care]=[_THISROW].[ID_care]),3)
,[ID_Package]=index(SELECT(care_Package[ID_Package],[id_care]=[_THISROW].[ID_care]),4))

))

[jyothis_m · Accepted solution]

IN() - AppSheet Help

[Laurent69]

Great! A big thank-you! It was very simple but I missed it and it's been a few hours since I spend on it