I see where there is an option to set column length min and max.
But my needs are just a bit different.
I only want it to accept a length of 18 or 33.
Nothing more, and nothing less.
Iv tried this:
(OR(LEN(columnName1) = 18, LEN(columnName1) = 33), "Valid", "Invalid")
and, no matter what i input, it says invalid.
And also, i dont know if this will go in app formula field, or data validity>"valid if" field.
Solved! Go to Solution.
To Check form input validity (Valid_If) - AppSheet Help use an expression that returns true if the input is valid. For example:
OR(LEN([[_THIS]) = 18, LEN([_THIS]) = 33)
User | Count |
---|---|
17 | |
11 | |
7 | |
5 | |
5 |