Question on Date Alert formula
First time posting and fairly new to Smartsheet when it comes to formulas and automations.
Can someone help with a date alert formula or can I do it in automations?
Let's use as something as a drivers license for example.
I am keeping a long list of people on when I receive their license and also recording the date on when it expires.
What I would like to do is set up color coding in the cell as we get closer to the expiration date and an alert each time the expiration date is met.
Yellow for 6 months
Red for 3 months.
Additional i would like email/alert to be sent when hitting these warnings.
Appreciate your help. Thank you
Help Article Resources
Check out the Formula Handbook template!