Automate At Risk Flag

Hello,

I am trying to automate an at-risk flag where the flag will turn red if the item is not 100% complete at the targeted due date.

Any Suggestions?


Thanks!

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hey @erayer

    A blank date cell is seen as "in the past", which is why you're seeing the flag.

    Try this:

    =IF([Target Date]@row = "", 0, IF(AND([Target Date]@row < TODAY(), [% Complete]@row < 1), 1))

    Cheers,

    Genevieve

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!