Forum Discussion

WesMcAda4's avatar
WesMcAda4
Qrew Champion
8 years ago

Checkbox Formula - field does not contain text

working with "Contains". Example: If(Contains(ToText([Approvals Needed:]),"Quality Assurance") and Contains([Approvals Logged],"Quality Assurance"),true) However, I cannot figure out how to change ...
App builders
Formulas and functions
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
8 years ago

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's avatar
    WesMcAda4
    Qrew Champion
    8 years ago
    Thanks for the idea.