ContributionsMost RecentMost LikesSolutionsRe: Seattle meetup anyone? I'd love to attend (particularly if it is north of the city)! ------------------------------ Amanda Thomas Business Systems Analyst Morse Steel Reinforcing Bellingham WA ------------------------------ Re: Formula to check for blank/null Multi-Select Text fieldThank you Mark. I just realized that the reason I was receiving an error even when using (ToText([Items Awarded]) was that I didn't have the next condition in the if statement. I appreciate your help ------------------------------ Amanda Thomas Business Systems Analyst Morse Steel Reinforcing Bellingham WA 360-756-6208 ------------------------------ Formula to check for blank/null Multi-Select Text fieldI 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, text ToText([Items Awarded]) = "" -- Expecting text but found bool [Items Awarded] = Null -- Expecting text but found bool ISNULL([Items Awarded]) -- Expecting number/date/datetime/TimeOfDay/duration/workdate/user/userlist but found textlist How 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 ------------------------------