Flag is true when status is not complete and date modified is 5 days old


Hello, in an effort to automate update request emails for items that have been stuck at a specific status for a period time, I am trying mark a flag as true when the row status is not complete, and the date modified is more than 5 days old.

I think I need an IF And formula and having difficulty incorporating the and statement. Does anyone have any recommendations?

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    =IF(AND(NOT(staus@row="Complete"), Modified@row<today(-5)), 1, 0)


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!