Formula question: If date exceeded another date, then...
New to smartsheets and I can't figure this out.
If Needed onsite 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 onsite]1, (then turn row red & notify assigned to)
How do I turn the row red and send a notification?
Best 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
Answers

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

Thank you Paul H!
Help Article Resources
Categories
Check out the Formula Handbook template!