Does Not Contain

Jennifer Langan

I am looking to write a formula which says

IF A1="removed" AND A2 Does not contain "ABC", "true",""

What is the correct syntax for "does not contain" in this case? (I just can't get the typical "<>*ABC*" to work as part of a logic expression in Smartsheet.

Thank you!

Andrée Starå

@Jennifer Langan

Happy to help!

Try something like this instead.

=IF(AND([A1]@row = "removed", NOT(CONTAINS("ABC", [A2]@row)), [A2]@row <> ""), "true")

Did that work?

Andrée Starå

Hi @Jennifer Langan

Try something like this.

=IF(AND([A1]@row = "removed", [A2]@row <> "ABC", [A2]@row <> ""), "true")

Did that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jennifer Langan

Thanks. That doesn't work because that would express, IF A2 is not "ABC", then value.

I need it to say IF A2 does not contain "ABC" (like there is more text in the cell than just ABC), then value

Andrée Starå

@Jennifer Langan

Happy to help!

Try something like this instead.

=IF(AND([A1]@row = "removed", NOT(CONTAINS("ABC", [A2]@row)), [A2]@row <> ""), "true")

Did that work?

Jennifer Langan

Yes! the "NOT(CONTAINS...." is exactly what I was looking for. Thank you!

Andrée Starå

@Jennifer Langan

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Anthony Barthelemy

@Andrée Starå I am trying to Add third Condition using Not Contain the Following in Labels Column to Return Blank. Can you Help?

Not Contain in Labels Column:

NOT_ACAMS 2.0

ACAMS_2.0

Result is Incorrect Argument

Current Formula:

=IF(CONTAINS("NOT_ACAMS_2.0", Labels@row), "NOT ACAMS 2.0", IF(CONTAINS("ACAMS_2.0", Labels@row), "ACAMS 2.0", OR(IF(NOT(CONTAINS("NOT_ACAMS_2.0", Labels@row), "", IF(NOT(CONTAINS("ACAMS_2.0", Labels@row), "")))))))

Anthony Barthelemy

Disregard! I figured it out

Andrée Starå

@Ray B

Glad you got it working!