Valid if more than one word

Hello, is it possible to force a user to enter 2 words in one column by using valid if?

0 5 112
5 REPLIES 5

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

Top Labels in this Space