Forum Discussion
ChrisChris
Qrew Assistant Captain
Since the function Contains is Boolean, check for a true condition anyway, then do the opposite of what you'd do if the [Approvals Needed:] contained "Sales".
if(contains(totext([Approvals Needed:]), "Sales", false,true)
Just turn around the true,false and make it instead false, true.
WesMcAda4
7 years agoQrew Trainee
Thanks for the idea.