How do I have the risk flag turn red for any line with status not completed by the end date?

I only have a completed date in there instead of a start and end date, is that why? I can't figure it out.


  • Katy H
    Katy H ✭✭✭✭✭✭

    Is "Completed Date" not filled out until the task is complete? If so you would need at least a target completion date column to build the formula that would trigger the flag function.

    If "Completed Date" is filled out, then you can follow the instructions below, changing the syntax to fit your sheet.

    Put this formula in on of the risk flag cells associated with a task. I am guessing at the names of your columns, so please adjust them accordingly.

    =IF(AND(NOT(Status@row="Complete"), TODAY()>[Completed Date]@row), 1, 0)

    Katy Hall

    Head of Product Management

    ILLA Canna


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    If @Katy H's formula doesn't work (I feel like it should based on my understanding of your structure), are you able to provide a screenshot for reference?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!