Long story short
-got two tables. “The Features” & “The Moderators”, which both have a column named [Moderator].
-Moderator table also has a column named [Status (Moderator)].
-I’m Using the entries in the [Moderator] column in 'The Moderator" table as an enum list for the “Moderator” column in a form that connected to “The Features” table.
–I would like to dynamically filter the enum list in “The Features” table with the text “Current Mod” in the [Status (Moderator)] column in “The Moderator” table.
-used the following code to so this. I get the “verified” check, but has no effect on my list. What am i doing wrong?
=SELECT(The Moderators[Moderator], CONTAINS(The Moderators[Status (Moderator)],“Current Mod”))
Swift help would be highly appreciated