Use IF And Statement to Flag

Options

This formula works correctly:

=IF(AND([Date Created]2 < TODAY(-3), NOT(Status2 = "Completed")), 1, 0)

If a ticket was created more than 3 days ago and the status of the ticket is not completed, flag the cell. It works.

Now I need to add Duplicate in addition to Completed. No matter how I change it I always get an error.

=IF(AND([Date Created]1 < TODAY(-3), NOT(Status1 = "Completed", "Duplicate")), 1, 0) this gets an error.

Any Ideas?

Best Answer

  • Frank S.
    Frank S. ✭✭✭✭✭✭
    Answer ✓
    Options

    Greetings @jcroft01

    Please try the following:

    =IF(AND([Date Created]@row < TODAY(-3), NOT(OR(Status@row = "Completed", Status@row = "Duplicate"))), 1, 0)

    I replaced the specific cell reference to the @row, so the formula can be used for the entire column.

    I hope this helps and please let me know if you have any issues.

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

Answers

  • Frank S.
    Frank S. ✭✭✭✭✭✭
    Answer ✓
    Options

    Greetings @jcroft01

    Please try the following:

    =IF(AND([Date Created]@row < TODAY(-3), NOT(OR(Status@row = "Completed", Status@row = "Duplicate"))), 1, 0)

    I replaced the specific cell reference to the @row, so the formula can be used for the entire column.

    I hope this helps and please let me know if you have any issues.

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

  • jcroft01
    Options

    That did the trick. Thank you@Frank.Smith !!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!