Help with Flag formula

erika14

I've tried a few different formulas using IF and ISBLANK but can't seem to figure this out, even after looking at a few post on here. Hoping you can help.

 

I need help with creating a formula for the following:

If a task is incomplete and the due date is in the past, a red flag will appear BUT if the 'due date' cell is blank, I do not want a red flag to appear.

 

My formula for the first part works: =IF(AND([Due Date]@row< TODAY(), NOT(Status@row = "Complete")), 1, 0)

 

I just cant figure out the no flag if no due date part. 

 

Thanks!

 

 

Andrée Starå

Hi Erika,

Try something like this.

=IF(ISBLANK([Due Date]@row); ""; IF(AND([Due Date]@row < TODAY(); NOT(Status@row = "Complete")); 1; 0))

The same version but with the below changes for your and others convenience.

=IF(ISBLANK([Due Date]@row), "", IF(AND([Due Date]@row < TODAY(), NOT(Status@row = "Complete")), 1, 0))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

erika14

Thank you! It worked

Andrée Starå

Excellent!

Happy to help!