Matching depending of 2 column

Christophe_Schn · 03-23-2020 07:44 AM

Hello,
I need help to find the expression for find the value in a list macthing with 2 others column;
I want the “ref number” depending of the column “installation” and “frequency”

WillowMobileSys

Welcome to AppSheet!!!

We might need more information to fully understand your intentions.

If your expression is operating on the SAME row, you can write and expression like:

AND([Installation] = "Install Value", [Frequency] = "Some Frequency")

If you are wanting to select a different row, whether it be in the same table or some other table, you might need an expression like this:

SELECT(Table Name[Ref Number], AND([Installation] = "Install Value", 
                                   [Frequency] = "Some Frequency")
)

This returns a LIST with ALL the "Ref Number"s that are in rows with the values “Install Value” and “Some Frequency”

If you are wanting to return “Ref Number” as just a single value then you can wrap the SELECT() with an ANY() function…BUT if the SELECT() returns multiple rows, ANY() will only give you the value of the FIRST row.

ANY(
    SELECT(Table Name[Ref Number], AND([Installation] = "Install Value",
                                       [Frequency] = "Some Frequency")
    )
)