Parameter 2 of function IN is of the wrong type

[FaCe]

Why this formula gives me the subject error?

COUNT(SELECT(PASSATI[ID],IN("Green",[CHECK])))>0

PASSATI is a slice

Green is the color (Type column) is saved in my Google Sheet database

CHECK is a column

[WillowMobileSys]

The second parameter of the function must be of a LIST type.  IN() 

If [Check] is a comma separated test value, you can use the SPLIT()  function to convert the comma separated values to a list.

If [Check] is Text and want to inspect if it has the word "Green" in it then you want to use the CONTAINS()  function instead

I hope this helps!

[FaCe]

[Check] is saved in my Google Sheets Database as text but it's a Color Column Type.

It's strange in other part of the App i use 

COUNT(SELECT(SCADENZA OGGI[ID],IN("ELISABETTA",[ASSEGNATA])))>0

And it extract from Database only records that have in Column Assegnata the word Elisabetta, why with color (that is saved in Database, as said, in the same text type) it doesn't work ?

[Sirfyaad]

---

@FaCe wrote:

COUNT(SELECT(PASSATI[ID],IN("Green",[CHECK])))>0

---

COUNT(SELECT(PASSATI[ID], [CHECK] = "Green")) > 0

[WillowMobileSys]

---

@FaCe wrote:

COUNT(SELECT(SCADENZA OGGI[ID],IN("ELISABETTA",[ASSEGNATA])))>0

And it extract from Database only records that have in Column Assegnata the word Elisabetta, why with color (that is saved in Database, as said, in the same text type) it doesn't work ?

---

[Assegnata] must have been defined in AppSheet as some list type column.

The expression by @Sirfyaad should work for you.