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

Bryan Mac

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?

Paul H

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

Paul H

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

Bryan Mac

Thank you Paul H!