Task@Risk

MZED

Hi.

I'm trying to create the following formula for a RAID Log Task@Risk, to display a Red Flag if criteria is met:

If [End Date] is blank, then "Update Date", If the STATUS chosen from the STATUS drop-down is "Not Started" or "In Progress" or "Cancelled" or "On Hold" or "Delayed" & [End Date] has passed Today's date, then "Red Flag"

I've tried this formula, but have not succeeded

=IF(ISBLANK([End Date]@row], "Update Date", IF(AND([Status@row] = “Not Started”, IF[Status@row] = “In Progress”, IF[Status@row] = “Cancelled”, IF[Status@row] = “On Hold”, IF[Status@row] = “Delayed”, IF[End Date]@row >= TODAY()),"Complete",”Red”)))

MZED

Thank you Paul

Paul Newcome

Is "Complete" the only status that wouldn't throw a flag if the end date is in the past?

MZED

Hi Paul

Thank you for the reply, unfortunately I only saw it today.

Is "Complete" the only status that wouldn't throw a flag if the end date is in the past? - YES

Paul Newcome

This should be a little more manageable:

=IF([End Date]@row = "", "Update Date", IF(AND([Status@row] <> "Complete", [End Date]@row <= TODAY()), 1))

MZED

Hi Paul.

I've tried this but it still isn't working. Please find screenshot below:

Best regards

Mark

Paul Newcome

My apologies. When copy/pasting I forgot to remove a set of square brackets. Try this:

=IF([End Date]@row = "", "Update Date", IF(AND(Status@row <> "Complete", [End Date]@row <= TODAY()), 1))

MZED

Thank you Paul

Paul Newcome

Happy to help. 👍️