IF with nested OR and AND

Hello,

I'm struggling with this formula and getting and incorrect argument error.

I'm wanting my priority column to give me the correct drop down ("Half") if either or both of my conditions or met. Here's what I have.

=IF(OR(AND([Micro or QC?]@row = "Micro", AND([Micro or QC?]@row = "QC"), "Half")))

I can get the formula to work with the OR statement, but I cannot get it to work if I try to add AND.

What am I missing here?

Find more posts tagged with

Accepted answers

Jeff Reisman

https://community.smartsheet.com/discussion/88484/if-with-nested-or-and-and

I think you're overthinking it. In evaluating a regular column, you just need the OR, because what OR really means in Smartsheet is "if at least one of these is true..."

=IF(OR([Micro or QC?]@row = "Micro", [Micro or QC?]@row = "QC"), "Half")

But with a multi-select column, you should use CONTAINS along with the OR.

=IF(OR(CONTAINS("Micro", [Micro or QC?]@row), CONTAINS("QC", [Micro or QC?]@row)), "Half")

All comments

Jeff Reisman

https://community.smartsheet.com/discussion/88484/if-with-nested-or-and-and

I think you're overthinking it. In evaluating a regular column, you just need the OR, because what OR really means in Smartsheet is "if at least one of these is true..."

=IF(OR([Micro or QC?]@row = "Micro", [Micro or QC?]@row = "QC"), "Half")

But with a multi-select column, you should use CONTAINS along with the OR.

=IF(OR(CONTAINS("Micro", [Micro or QC?]@row), CONTAINS("QC", [Micro or QC?]@row)), "Half")

Sarah Waldrop

Hello!

I was definitely overthinking it. 😌

Thank you so much!

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.