Hey folks,
Help!
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
Your expression should be in the Valid_If field of the [Moderator] column of the The Features table. If it is, I would expect it to work.
thanks for the input @Steven_Coile I shouldโve mentioned that this was the field i put the expression in previously, so that suggestion doesnt work. Do you, or anyone else, have any other ideas about what the problem could be?
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |