Flagging Red using two conditions

Desperately trying to find a formula that does this: if due date is past and checkbox is blank then flag red in Symbol column

For Row 15, tried this but it is not parseable.

I used this formula in the Flag column

=IF(AND([Checkbox]15 < 1,TODAY()>[Finish]15)1)

says UNParseble

Find more posts tagged with

Project Management

Comments

Tasnia

Example is Row 15.

Finish is my End or Due Date column, Checkbox is - done or not column, and in the Flag column I want the flag to be Red if:

Date is past due, and Checkbox is not ticked...

Have tried this (I'm completely new at this):

=IF([Finish]15 < TODAY() AND ([Checkbox]15 0), 1, 0)

But it is UNPARSEABLE,

Tasnia

At the moment I have this in the flag column working: (flag goes red)

=IF([Finish]15 < TODAY(), 1, 0)

The flag turns red if Due Date or Finish is past today's date, the flag goes red. What I want is for the flag not to turn red if the job is complete (Checkbox ticked).

Mike Wilday

=IF(AND(Checkbox15 = 0, TODAY() > Finish15),1 ,0)

This should work. Put it in the flag column row 15. You were missing the commas after the AND statement closure.

Tasnia

Thanks so much Mike. That was awesome. Worked like a charm!