I am writing custom data rules and would like to have a rule that when a specific Multi-Select Text field [Items Awarded] is blank/null the record cannot be saved.
I've tried using each of the following, and each returned an error
[Items Awarded] = "" --
The operator '=' can't be applied on types textlist, textToText([Items Awarded]) = "" --
Expecting text but found bool[Items Awarded] = Null --
Expecting text but found boolISNULL([Items Awarded]) --
Expecting number/date/datetime/TimeOfDay/duration/workdate/user/userlist but found textlistHow do I use a formula to check for blank/null Multi-Select Text fields?
------------------------------
Amanda Thomas
Business Systems Analyst
Morse Steel Reinforcing
Bellingham WA
360-756-6208
------------------------------