So first the slice should make sure the field [Group assigned to] isnt blank. I then need it to search the “Staff” table and field [group] and compare it to the [Group assigned to] field. I used contain as the [group] field is an enum list and people can be apart of several groups. the [group assigned to] is enum.

Now It is not showing any errors but in testing if I change the [group assigned to] to something else the data no longer shows but it should as what i am changing it to the staff member is apart of that group.

When you use the IN expression, you would not need the ISNOTBLANK if your group field is mandatory. Your formula seems to be correct so… check that your group name is written exactly in the same way. Uppercase matters.