If with And Formula help


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?


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)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!