Need Formula

Jeremy Klingensmith

I need a formula that will raise the flag when the following conditions are met:

-If Status reads "Not Started" or "Complete"

AND

-If Start Date is less than TODAY

Paul Newcome

Give this a go.

=IF(AND(OR(Status@row = "Not Started", Status@row = "Delayed"), [Start Date]@row < TODAY()), 1)

Paul Newcome

Try this one...

=IF(AND(OR(Status@row = "Not Started", Status@row = "Complete"), [Start Date]@row < TODAY()), 1)

Jeremy Klingensmith

Hey Paul - I'm still having difficulty. Maybe I dont have the right conditions identified?

Also - I had to make the following correction to the conditions I gave you originally:

-If Status reads "Not Started" or "Delayed"

AND

-If Start Date is less than TODAY

For some reason I am still getting the flag raised when the task is marked as Complete.

Here is the formula I am using:

=IF(OR(Status4 = "Not Started", Status4 = "Delayed", [Start Date]4 < TODAY()), 1, 0)

Paul Newcome

Give this a go.

=IF(AND(OR(Status@row = "Not Started", Status@row = "Delayed"), [Start Date]@row < TODAY()), 1)

Jeremy Klingensmith

Amazing! Thank you, Paul!🙂

Paul Newcome

Happy to help! 👍️