Flag formula

I'm struggling with the flag formula even after reading these discussions and downloading the formula tools.

Goal is to:

  • Flag if status is not “complete” and due date in the past
  • Flag if status is blank and due date is less than or equal to 3 days from today

Current formula that works is below. I've tried adding to it without luck:

=IF(ISBLANK(End@row), "", IF(AND(End@row <= TODAY(), Status@row <> "Complete"), 1))

Columns are standard - start, end, status.



  • Alpha Chucky
    Alpha Chucky ✭✭✭✭

    Hi @JenS

    I modified your formula for your goals. I hope this helps:

    =OR(AND([End Date]@row <= TODAY(), Status@row <> "Complete"), AND(ISBLANK(Status@row), [End Date]@row <= (TODAY() + 3)))

    Let me know how it goes.

    Good luck!

    Projects Delivered. Data Defended.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!