I need a formula to flag a task

Christine Adams

I need help with a formula.

I want to use this formula for the Due Date but I need to modify it so I can add in criteria if the Start Date has been passed & the task Status shows either Delayed or Not Started

=IF([Due Date]@row = "", "", IF(AND(OR(Status@row = "Not Started", Status@row = "Assigned", Status@row = "Scheduled", Status@row = "In Progress"), [Due Date]@row <= TODAY(-2)), 1, 0)

Thanks

Genevieve P.

Hi @Christine Adams

I presume you want "1" to appear (or the flag to be checked) with the additional criteria, is that correct?

If so, we can add these statements into your AND function within another OR, like so:

=IF([Due Date]@row = "", "", IF(OR(AND(OR(Status@row = "Not Started", Status@row = "Assigned", Status@row = "Scheduled", Status@row = "In Progress"), [Due Date]@row <= TODAY(-2)), AND(OR(Status@row = "Delayed", Status@row = "Not Started"), [Start Date]@row > TODAY())), 1, 0)

Cheers,

Genevieve