Multiple Not options in an IF(And Statement

Brett G

Hello, Right now I have a working formula: =IF(AND([End Date]@row < TODAY(), NOT(Status@row = "Complete")), 1, 0). using this to trigger a risk flag.

I'd like to add more status values into the Not(Status@row portion.

Looking to add 3: Complete, Ongoing, Cancelled. These are 3 status values where I do not want an at risk status flag to trigger past task due date.

Any ideas?

Andrée Starå

Hi @Brett G

I hope you're well and safe!

What are all the different staus options you have?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Brett G

Hi @Andrée Starå ,

Here is my option total set:

• Not Started, In Progress, On Hold, Complete, Canceled, Ongoing

If a project task is past its due date, I'd only like to trigger a risk flag for these status values:

• Not Started, In Progress, and On Hold.

and NOT trigger a flag for status:

• Complete, Canceled, and Ongoing.

This will be great to figure out if this is possible, thank you.

Bassam Khalil

Hi @Brett G

Hope you are fine, please try the following formula:

=IFERROR(IF(AND([end date]@row < TODAY(), OR(Status@row <> "Complete"),
Status@row <> "Ongoing", Status@row <> "Cancelled"), 1), "")

Brett G

Hi @Bassam Khalil,

I copied your formula into my column formula, but unfortunately it gave me a syntax error. I tried a couple of other things with what you sent over, but no luck.

Thank you for trying to help me. Any other ideas I should try?