Check if value is in Enumlist Column

AppSheet AppSheet Q&A
1

From the “Job” table, I have a column called [Team ID] holding emails from the “Team” table, and I have a [Rescue] column that is of type EnumList that also holds emails from the “Team” table. I am trying to use a VC of type y/n named [Rescuer] to see if the [Team ID] in one row can be found in another row of the Job table in the [Rescue] column.

IN([Team ID], [Rescue])
Seems to be what I need but it returns N no matter what.
I thought it was because it’s an EnumList, so I tried
IN([Team ID], LIST([Rescue]))
Any help greatly appreciated.

2

Both [Team ID] and [Rescue] are EnumLists and they are in the same “Job” table, right?

3

Yes, they are both in the same Job table, but [Team ID] is a Ref to an email column in the “Team” table.