I want to use a list of values from another i...

I want to use a list of values from another in the valid_if field of a column but I don’t want the dropdown. I just want the app to check the users input. Is that possible?

0 2 301
2 REPLIES 2

If your Valid_If contains solely an in() expression, AppSheet works some magic and produces a drop-down menu with the values matched by the in(). To avoid this magic behavior, you have to disguise your use of the in() function. The simplest way is to make it part of another, benign expression:

=and(true, in(…))

+Steve Coile Thanks! That worked perfectly.

Top Labels in this Space