Data filter against ref values

Hello,
I would like to get a filter on a column of a table against the value (Ref) of another column of this same table.

In table 1 I have Key + two columns

image


In table 2 I have too Key + two columns

  • Columns “Client/BSI” = Ref ==> Table 1 [Nom Société]

When I select my client, I want only the affiliated subsidiaries to appear in column 2


For the “Subsidiary” column I tried the following formula but it does not work because it shows me all the values, regardless of the “Client / BSI” selected

image

image

I tried other formulas referenced in tutorials but they don’t work either.

Could you help me please?

thank you so much

Try:

IFS(
  ISNOTBLANK([Client/BSI]),
    SELECT(
      Clients[Nom Filliale],
      AND(
        ISNOTBLANK([Nom Filliale]),
        ISNOTBLANK([Nom Societe]),
        ([_THISROW].[Client/BSI] = [Nom Societe])
      )
    )
)
1 Like

Thank you so much Steve but it’s note ok :sweat_smile:

When I enter your formula, I no longer have any values displayed in “Filiale”

image

Thank you so much Steve

Please contact support@appsheet.com for further help with this.