If / and / contains formula

Hello,

Trying to get a formula to check an "active" box if two conditions are presents. Essentially when both these if conditions are true.

IF(CONTAINS(Docs@row, {Active Docs}, 1, 0))

IF(CONTAINS([Trade Partner]@row, {Active Clients}, 1, 0))

Trying the below gives me an #INCORRECT ARGUMENT

=IF(AND(CONTAINS(Docs@row, {Active Docs}), CONTAINS([Trade Partner]@row, {Active Clients}), 1, 0))

Would appreciate any help. Thanks!

Find more posts tagged with

Formulas

Accepted answers

SmartLew

one more bracket after {Active Clients}, one less bracket after 0:

=IF(AND(CONTAINS(Docs@row, {Active Docs}), CONTAINS([Trade Partner]@row, {Active Clients})), 1, 0)

All comments

SmartLew

one more bracket after {Active Clients}, one less bracket after 0:

=IF(AND(CONTAINS(Docs@row, {Active Docs}), CONTAINS([Trade Partner]@row, {Active Clients})), 1, 0)

SmartLew

hey @jonnyp

did the above solve your issue?

jonnyp

Hi @SmartLew. That worked... but made me realize that those CONTAINS functions aren't doing what I needed them to. 2 steps forward, 1 step back.

SmartLew

https://community.smartsheet.com/discussion/comment/344474#Comment_344474

what is it you are trying to achieve? Let me see if I can help

jonnyp

I was trying to conflate 2 separate statuses into one column but ended up breaking them out and it achieved what I needed. Thanks for your help.

Sarita Sah

Please help with this formula. its returning as Incorrect Argument. I want to display "Completed" Or "Pending" if two different words or combination i.e. "No" and "Complete" available in the status column.

@Paul Newcome, @Bassam Khalil, @SmartLew

=IF(AND(CONTAINS("No", Status@row, CONTAINS("complete", Status@row, "Completed", "Pending"))))

Genevieve P.

Hi @Sarita Sah

Do you mean if either "No" OR "Complete" are found in the Status cell?

If so, try this:

=IF(OR(CONTAINS("No", Status@row), CONTAINS("complete", Status@row)), "Completed", "Pending")

It looks like you were just missing the closing parentheses for each of your functions.

Cheers,

Genevieve

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.