IF formula with AND and NOT



I'm trying to get a "yes" or "no" answered based on the conditions below. I'm receiving the "incorrect argument set" error; however, I am unable to determine where the error is found. Thank you in advance!

  1. If date is today or in the past
  2. the status is: anything but complete

=IF(AND([Target Start Date]@row < TODAY(), IF(NOT(Status@row = "Complete"), "Yes", "No")))

Best Answer

  • Daryl Lee
    Daryl Lee ✭✭✭
    Answer ✓

    Instead of using not, you can have the second statement be not equal to complete. The following should work:

    =IF(AND([Target Start Date]@row < TODAY(), Status@row <> "Complete"), "Yes", "No")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!