Question

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 · Accepted 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