Adding at risk based on health color


I'm trying to make a formula to set a flag in the at risk column based on whether the health is red and at least 3 days past the due date. Something isn't behaving quite right on the 3 days part and it's flagging some things that are not yet 3 days past due....

Here is what I have, is this not correct?

=IF(AND((Health@row = "Red"), [End Date]@row < TODAY(3)), 1, 0)


Best Answer

  • JamesB
    JamesB ✭✭✭✭✭✭
    Answer ✓


    I am not sure the formula you have for your health column, but I recreated the referenced columns in your formula and I do not see any issues with the corrected formula @DKazatsky2 provided to meet your criteria as detailed out in your initial request.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!