Checkbox Formula - field does not contain text

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress

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 it to work from the condition that the field "does not contain" something.
Example using "excludes" as the opposite: If(Exludes(ToText([Approvals Needed:]),"Sales"),true)

I do not know how to write this where not having certain text included in the field is the condition. Any help?

Thank you~

Photo of Wes McAda

Wes McAda

  • 198 Points 100 badge 2x thumb
  • like I am running out of time

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
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)