Valid if Behavior

[Jerry_Lan]

Dear all,

When I put the following expression:

IN([_This],Registration[ID]) , in valid if…am I right it should not show a dropdown of values? It should wait for the user to input first and then check if the input is in the list Registration[ID]…

Jerry

[Aleksi · Accepted solution]

It will generate a dropdown. If you type it like AND(TRUE,IN([_THIS],Registration[ID])), it should work.

[Jerry_Lan]

Thanks Aleksi! That’s very clever!

[Aleksi]

You’re welcome