Does Not Contain
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!
Best Answer

Happy to help!
Try something like this instead.
=IF(AND([A1]@row = "removed", NOT(CONTAINS("ABC", [A2]@row)), [A2]@row <> ""), "true")
Did that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers

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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

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

Happy to help!
Try something like this instead.
=IF(AND([A1]@row = "removed", NOT(CONTAINS("ABC", [A2]@row)), [A2]@row <> ""), "true")
Did that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

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

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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

@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), "")))))))

Disregard! I figured it out

Glad you got it working!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!