IF/AND Statement


I am trying to write a formula where a box will be checked if a date listed is older than 10 days, AND if the status in another column is listed as "UNAPPROVED." I got the date part down already, but I'm having trouble adding in the second expression. Anyone have any ideas? This is what I have now:

=IF(AND([Entry/Routing Date]1 < TODAY(-10), 1), ([INV Status]="UNAPPROVED"))

It's coming back with the error message #UNPARSEABLE.

Thanks for your help!

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 02/22/21 Answer ✓

    Hi @Meredith Kay

    Hope you are fine, please try the following formula

    =IF(AND([INV Status]@row = "UNAPPROVED", [Entry/Routing Date]@row < TODAY(-10)), 1)

    PMP Certified


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!