Red Flag If statement

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)

Find more posts tagged with

Formulas

Government

Project Management

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Circular Reference with formula
i am not good with writing formulas within a sheet. I asked the AI tool in the sheet to help me write a formula and I am getting a Circular reference back. I'm trying to have it write the following formula for me. If the column "Tracking #" is not blank, change Column "Deployment Phase" to "Shipped" I have tried adding in…
How to delay the execution of a workflow whose trigger occurred much earlier?
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…
INDEX/COLLECT??
Having trouble with an INDEX/COLLECT/CONTAINS formula. I have two sheets, my source and my destination; the source sheet has a column I want to collect into the destination. -Tool ID, is in both sheets and the target of the INDEX/MATCH, the source sheet might have this listed 6 or 7 times -Purpose of Device, there are…