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!

Best Answer

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    edited 01/13/22 Answer ✓

    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)

Answers

  • Mike Wilday
    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?

  • 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
    Mike Wilday ✭✭✭✭✭✭
    edited 01/13/22 Answer ✓

    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)

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

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

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

  • This worked!! Thank you so much!!

  • Sarah Waldrop
    edited 01/17/22

    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
    Mike Wilday ✭✭✭✭✭✭

    You're welcome!

Help Article Resources