Flagging Late Tasks

Katye Reed

Hi,

I am struggling to flag items as late. If Rounding Complete is not checked and the due date is greater then today I want to flag those items.

=IF(AND([Rounding Complete]@row, "1", [Date Rounding Scheduled]@row,<= TODAY()), "Red"))

Note sure where I am going wrong here.Thanks!

Paul Newcome

=IF(AND([Rounding Complete]@row, 0, [Date Rounding Scheduled]@row <= TODAY()), "Red"))

0 Is the output for unchecked, and you had an extra comma between the Date Rounding and TODAY(). Give the above a try.

Katye Reed

Hi Paul,

I am still receiving an unparseable error when I use the above formula. Why is something so simple, so difficult to accomplish? 🤔

Paul Newcome

My apologies. I missed the extra closing parenthesis at the end. Removing that should have it working for you.

=IF(AND([Rounding Complete]@row, 0, [Date Rounding Scheduled]@row <= TODAY()), "Red")

Katye Reed

Ha! I figured it out - =IF(AND([Date of Rounding]@row < TODAY(), [Rounding Complete]@row < 1), 1, 0)

Paul Newcome

Ah. Ok. I assumed you were using the colored balls since you had "Red". I didn't realize you were using an actual flag column.

For flag and checkbox columns, 1 = true and 0 = false when being referenced in formulas.

Bruce Southers

@Katye Reed Hi Katye, are you setting up a checkbox column for this? If so, where are you adding the formula? I use a Start Date and Finish Date in the project plan, and then want to autopopulate the task checkbox (if possible) when a task is past the Finish Date and not marked as Completed. I found this thread when searching for a late task formula.

Thanks!

Bruce

Paul Newcome

@Bruce Southers You are going to want something that looks like this...

=IF(AND(TODAY()> [Finish Date]@row, [% Complete]@row <> 1), 1)

The above is assuming you are using a % Complete to mark the task as complete. If not, you may need to adjust column name/criteria to suit your needs, but the overall idea of using IF/AND will still be the same.

Bruce Southers

@Paul Newcome This is great, thanks! Yes, I use the % Complete field.

Paul Newcome

Happy to help. 👍️