Date ranges and symbols


I am looking for a formula to automatically change a symbol colour based on contract expiry dates. Here is what I need each symbol to signify about the expiry date column -

Green dot = If the contract expiry date is greater than 365 days from today

Yellow dot = If the contract expiry date is less than 365 days away from today

Blue Dot = if the date has past todays date

Red dot = box not populated

All help will be gratefully received.

It would also be cool to get up a notification when the symbols change colour.

Thanks in advance



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!