Formula question: If date exceeded another date, then...


New to smartsheets and I can't figure this out.

If Needed on-site date column is greater than Estimated Lead Time column then I need the row to turn red and notify Assigned To column

This is where I'm at so far...

=IF([Estimated Lead Time]1 > [Needed on-site]1, (then turn row red & notify assigned to)

How do I turn the row red and send a notification?

Best Answer

  • Paul H
    Paul H ✭✭✭✭✭✭
    Answer ✓

    Add a symbols column with RGB balls, and put your formula in that column

    in your formula use value_if_true = "Red"

    Create an conditional formatting that changes the row color when the RGB column turns

    Create an notification workflow the triggers when the RGB turns red


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!