I have a behavior that I do not want to show if the referenced Title column is not found in the referenced table . I’m having some difficulty constructing the correct filter statement.
My table:
The table being referenced is Form Responses:
So if Title in Gcal does not appear as the UNIQUEID in Form Responses I do not want the behavior to appear.
I’ve tried this FILTER("Form Responses", ([_THISROW] = [UNIQUEID]))
but get this error:
The expression is valid but its result type ‘List’ is not one of the expected types: Yes/No
User | Count |
---|---|
16 | |
13 | |
8 | |
7 | |
4 |