Need help with an IF Statements with multiple ORs and an AND

Options

Hi. I need to write an IF statement where if the Review column has one of the following: Review Complete, Reviewed - Not applicable, Do not include, Reviewed - Not applicable, send feedback

AND

the COMM Review column has the following: COMM Review Complete

If both the Review Column has one of the 3 options AND the COMM Review column has COMM Review Complete, then enter "All Reviews Complete" in the All Reviews Complete column.

This is the formula I wrote, but I'm getting a unparseable error:

=IF((AND(OR([Review Complete]@row = "Review Complete", [Review Complete]@row = "Reviewed - Not applicable, Do Not Include", [Review Complete]@row = "Reviewed - Not applicable, send feedback")), IF([COMM Review Complete]@row = "COMM Review Complete"), "All Reviews Complete", " "))

If neither of the conditions are fullfilled, then leave the All Reviews Complete column blank.

Thoughts?

Thanks,

Adrienne

Best Answer

  • L_123
    L_123 ✭✭✭✭✭✭
    edited 11/07/22 Answer ✓
    Options

    Sorry. went a little fast on that one.

    IF(AND(OR([Review Complete]@row = "Review Complete", [Review Complete]@row = "Reviewed - Not applicable, Do Not Include", [Review Complete]@row = "Reviewed - Not applicable, send feedback"), [COMM Review Complete]@row = "COMM Review Complete"), "All Reviews Complete", " ")

Answers

  • L_123
    L_123 ✭✭✭✭✭✭
    edited 11/02/22
    Options

    IF((AND(OR([Review Complete]@row = "Review Complete", [Review Complete]@row = "Reviewed - Not applicable, Do Not Include", [Review Complete]@row = "Reviewed - Not applicable, send feedback"), [COMM Review Complete]@row = "COMM Review Complete"), "All Reviews Complete", " "


    Give that a try

  • Hi L_123,

    I tried the formula you suggested, but there were a few missing parenthesis. So this is the formula I used with the parenthesis:

    =IF((AND(OR([Review Complete]@row = "Review Complete", [Review Complete]@row = "Reviewed - Not applicable, Do Not Include", [Review Complete]@row = "Reviewed - Not applicable, send feedback")), [COMM Review Complete]@row = "COMM Review Complete"), "All Reviews Complete", " ")

    Unfortunately, I still am receiving an #unparseable error.

    Thanks,

    Adrienne

  • L_123
    L_123 ✭✭✭✭✭✭
    edited 11/07/22 Answer ✓
    Options

    Sorry. went a little fast on that one.

    IF(AND(OR([Review Complete]@row = "Review Complete", [Review Complete]@row = "Reviewed - Not applicable, Do Not Include", [Review Complete]@row = "Reviewed - Not applicable, send feedback"), [COMM Review Complete]@row = "COMM Review Complete"), "All Reviews Complete", " ")

  • That worked! Thanks!!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!