Red Flag If statement

PJKeating

I have an if statement that is doing what I need except when there is no value in the deadline column. I want to keep the functionality I have but make sure the flag is not red when I have no deadline set.

=IF(AND(Deadline2 < TODAY(2), Completed3 = 0), 1, 0)

Andrée Starå

Hi,

Try something like this.

=IF(ISBLANK(Deadline2); ""; IF(AND(Deadline2 < TODAY(2); Completed3 = 0); 1; 0))

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

=IF(ISBLANK(Deadline2), "", IF(AND(Deadline2 < TODAY(2), Completed3 = 0), 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?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

PJKeating

That did the trick! Thank you! 

 

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée

PJKeating

What would I need to add to the formula to make the flag stay raised if the deadline is today or passed the deadline? 

PJKeating

=IF(ISBLANK(Deadline8), "", IF(AND(Deadline8 < TODAY(4), Completed8 = 0), OR(AND(Deadline8 >= TODAY(), Completed8 = 0), 1, 0)))

This seems to be working, do you see any issues with this logic?

 

Andrée Starå

At a glance, I don't.

I would only recommend if possible to change the row numbers to @row, so you don't have to think about the row numbers.

Hope that helps!