Hello, is it possible to force a user to enter 2 words in one column by using valid if?
Yes it is, you can use [_This]="TheWordYouWant" you can use [_This] to call the contant of that spacific column.
It needs to be any words, not word specific, but just needs to be two different words
COUNT(UNIQUE(SPLIT([_THIS], " "))) > 1
COUNT((SPLIT([_THIS], " ")) > 1 this without the unique if you want to contains the same word 2 times.
Thanks very much for both those suggestions
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |