I do NOT get an error when my Show_If is Table[Field] (Boolean), but I get an error if I use it as if( Table[Field], true, false). Thoughts?
Itโs a limitation in the syntax checker. It has a lot of flaws like that. Both of your expressions are bad.
I thought my Table[Field] would return a true or false since my [Field] is a Boolean field in my Table. Iโm using โTableโ as a placeholder of the name of my Table and โFieldโ as the placeholder of my Boolean field. My actual syntax in the Show_If is Filtering[Show Name] since Filtering is the name of my Table and โShow Nameโ is the name of my Boolean field.
What syntax can I enter in the Show_If to get the true or false stored in my Filtering[Show Name]?
Thank you.
Table[Column]
always returns a List type.
You might try ANY(), or INDEX(), or LOOKUP() ,which is just ANY(SELECT())
Thank you! I used the following and it is exactly the behavior I wanted.
IF( IN( CONTEXT( โViewโ), LIST(โProficiency Funnelโ, โProficiency Resultsโ) ), ANY ( SELECT(Filtering[Show Name], [Email] = USEREMAIL() ) ), true )
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |