In() function

[Andy_strathmore]

I want to check exsiting values in one row.with In() functon.

For example, if row group = 1 and color = yellow is exsiting, then return true.

Using In() function as follows

And( In( [group], 1 ), In([color], yellow))

will get the same result in following situation

because in group column, there is 1 so In([group], 1 ) = true

in color column there are yellow, so in([color], "yellow" ) = ture.

Any one can give me a hint of checking exsiting row which need to match multiple values.

Thanks

[Aurelien]

Hi @Andy_strathmore 

I don't get how your data structure could lead to the situation you describe.

You may want to remember the use of the IN() expression:

IN(itemYouLookFor,ListOfItemsToBeSearched)

At the best, you may have:

AND(
 IN(1,YourTable[group]),
 IN("yellow",yourTable[color])
)

For reference:

https://help.appsheet.com/en/articles/2357277-in

[Andy_strathmore]

You are right! thank you very much.

[Craig_QREW]

Alright, up first I believe your IN function is not set up correctly. I will attach the link to documentation about the IN() function at the bottom. 

1. Ensure that the area you are entering your expression is evaluated at the row level. 

2. Your formatting should be changed so it reads IN(1,LIST([group])) so the value you are looking for then a list of where you are wanting it to be found. When you do this here is how it is read. Is the number 1 in the list of the current row in the groups column. 

This accomplishes what you want which is to see if in the same row is 1 in the group column. 

3. After this do the same with the color, same set up and style. A complete expression should be like this: 

AND(IN(1,LIST([group])),IN("yellow",LIST([color])))

That should get you set up well. Please let me know if that doesn't work and I can be of further assistance. 

Craig 

QREW Technologies

IN() 

[Andy_strathmore]

Thank you Craig.

I have a double check of In function and set up correctly.Then it works. Appricated!

[Steve · Accepted solution]

ISNOTBLANK(
  FILTER(
    "table",
    AND(
      (1 = [group]),
      ("yellow" = [color])
    )
  )
)

[Andy_strathmore]

Thank Steve ! Problem Solved.