Red Flag If statement

PJKeating · 06/17/19

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å · 06/18/19

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 · 06/18/19

That did the trick! Thank you!

Andrée Starå · 06/18/19

Excellent!

Happy to help!

Best,

Andrée

PJKeating · 06/20/19

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 · 06/20/19

=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å · 06/25/19

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!

Red Flag If statement

Comments

Help Article Resources

Categories