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
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
Not 100% on this, but try:

If(Contains([My Field], "Banana")=false, "Yes there are no Bananas", "No there are no bananas")

Does that make sense?

Basically asking if the contains is false, rather than asking if its true.

(Might work)