Syntax with a mix of or, and, contains and not

Hello All,

My formula is:

=IF(OR([Box Shrubs#]@row >= 2, AND([Box Shrubs#]@row = 1, NOT(CONTAINS("hedge", [FN: Pruning]@row),1, "")))))

So basically, if the number at box shrubs is greater and equal to 2 then mark box; OR if box shrubs is equal to one AND the cell Fn: pruning does not contain hedge, then mark box

I keep getting syntax issues or @#incorrect argument.

Find more posts tagged with

Accepted answers

Melissa Yamada

Hello @Craig Lemberger

You're parenthesis at the end are causing the issue.

It should be:

=IF(OR([Box Shrubs#]@row >= 2, AND([Box Shrubs#]@row = 1, NOT(CONTAINS("hedge", [FN: Pruning]@row)))),1, "")

Once you're creating a formula there is a reference that shows up that will help you identify whether you're in a logical statement, value if yes, value if false, or criteria of any function. You can utilize that to identify why your formula is throwing an error message:

Screenshot 2025-03-09 at 10.35.29 AM.png

All comments

Melissa Yamada

Hello @Craig Lemberger

You're parenthesis at the end are causing the issue.

It should be:

=IF(OR([Box Shrubs#]@row >= 2, AND([Box Shrubs#]@row = 1, NOT(CONTAINS("hedge", [FN: Pruning]@row)))),1, "")

Craig Lemberger

you did it again @Melissa Yamada!

Thanks so much!!!!

Melissa Yamada

Happy to help! 😊

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.