Red Flag Trigger based on multiple conditions

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!


Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    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)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!