Select from a list to validate

[Ben_Rix]

Hey Everyone,

I’m trying to set a valid if constraint for a session to be created. I want the session that is to be booked to validate whether the parent table (Client Case) has a column (Status) value as active.

I have this at present:

IFS(SELECT(Client Case[Status], [_THISROW].[Ref] = [Ref]) = Active, True, False)

Problem is that my Status column is a list, so Im getting the Cannot compare list with text. After doing a little research I found that I should more than likely use the IN() function, but I cant seem to figure out how to fit it in to make it work.

Could someone please offer some advice.

Kind Regards
Ben