Flag formula

JenS

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

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!