If with And Formula help

Hello,

I'm trying to write an If with And formula to flag if my micro/QC column contains a specific phrase, and my Date Submitted column is past its date by 12 days.

Here's what I have =IF(AND([Date Submitted]@row - TODAY() >= 12, [Micro/QC?]@row = "QC", 1, 0))

I'm getting incorrect argument set error and can't figure out what I'm missing.

Any suggestions?

Thanks!

Find more posts tagged with

Sheets

Formulas

Accepted answers

Mike Wilday

Yes, you weren't closing the CONTAINS statement at the right place. It should have had a closing parenthesis closing CONTAINS, and then Closing the AND statement right after it. I moved one of the parenthesis from the end to that location. Let me know if this works?

=IF(AND([Date Submitted]@row >= TODAY() - 12, CONTAINS("QC", [Micro/QC?]@row)), 1, 0)

All comments

Mike Wilday

You need to put your then statement in there and if desired then your else statement.

=IF(AND(And 1, And 2), THEN, ELSE)

In your case, you would want your QC "due date" formula. IF both of those things are true, what date do you want to be represented?

Sarah Waldrop

Hi Mike

I simply want to the formula to flag if both statements are true. I've tried both of these formulas separately, without the AND, and gotten them to work, but I can't seem to get them to work together. Can you spot any problems?

=IF(AND([Date Submitted]@row >= TODAY() - 12, CONTAINS("QC", [Micro/QC?]@row) 1, 0))

Thank you

Mike Wilday

=IF(AND([Date Submitted]@row >= TODAY() - 12, CONTAINS("QC", [Micro/QC?]@row)), 1, 0)

Sarah Waldrop

Unfortunately I'm still receiving the #UNPARSEABLE error with your formula.

Mike Wilday

Try again. I forgot a comma before the 1. Just updated it.

Sarah Waldrop

This worked!! Thank you so much!!

Sarah Waldrop

This is the formula that I settled on:

=IF(AND([Date Submitted]@row <= TODAY() - 12, CONTAINS("QC", [Micro/QC?]@row)), 1, 0)

It works except... If the date submitted row is blank, the flag is triggered which isn't ideal.

NVM I found my fix! Thanks for everything!

Mike Wilday

You're welcome!

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.