Data filter against ref values

[Romain_GICQUEL]

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

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

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

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

How do I get a list of rows of this thing only? FILTER( "My Table", ([_THISROW].[Thing] = [Thing]) ) Replace My Table with the name of the table whose row you want; and Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID).

Could you help me please?

thank you so much

[Steve]

Try:

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

[Romain_GICQUEL]

Thank you so much Steve but it’s note ok

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

Thank you so much Steve

[Steve]

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