CASE WHEN equivalent in AppSheet operating on a list column

[leeca]

How to categorize a list column?

For example, I have 3 rows in my table, the column type is List and column name is [Purchase Status]:

1. {To Purchase, Purchase Complete}
2. {Purchase Complete, Purchase Complete}
3. {To Purchase, To Purchase}

To further categorize my [Purchase Status], I have tried using:

SWITCH(
  ANY(UNIQUE(LIST([Purchase Status]))) = "To Purchase", "To Purchase",
  ANY(UNIQUE(LIST([Purchase Status]))) = "Purchase Complete", "Purchase Complete",
  "Partially Purchased"
)

But got the error: 

Cannot compare List with Text in (ANY(UNIQUE(LIST([Request Item Status]))) = "To Purchase")

I am trying to achieve:

If all values in the list is "To Purchase", return status = "To Purchase",

if all values in the list is "Purchase Complete", return status = "Purchase Complete",

else return "Partially Purchased"

[graham_howe · Accepted solution]

If you want to check an item against a list, use IN() instead of '='.

https://help.appsheet.com/en/?q=In 

Update: hit send too soon

Using IN() you can first check if "Purchase Complete" is in the list, if it is not, then the result will be "To Purchase". Then check if "To Purchase" is in the list, if it is not then the result is "Purchase Complete". Else the answer is "Partially Purchased"