Red Flag Trigger based on multiple conditions

Tess H

Hello! I am attempting to adjust the red flag trigger in a RAID log so that it only displays if the due date is in the past and the status is "In Progress" or "Not Started."

The other option would be if the due date is in the past or the status is not "Complete.

My equation attempts continue to return as unparseable.

All help is appreciated!

Carson Penticuff

This will set the flag to active if the due date is is the past and the status is either In Progress or Not Started.

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

Carson Penticuff

It looks like you only missed an equals sign.

=IF(AND([Due Date]@row < TODAY(), [Status]@row = "In Progress"), 1, 0)

Tess H

Thank you! This worked! Do you know if it is possible to also have the flag display red when "In Progress" or "Not Started?"

Carson Penticuff

This will set the flag to active if the due date is is the past and the status is either In Progress or Not Started.

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

Tess H

Thank you so much!

This worked perfectly!