Traffic Light Conditional

Hi, I'd like to know if possible to do the following in Smartsheet.

I want to have a traffic light cell (green, red and yellow) that every time I open the sheet it would change base on:

  1. Green - if the contract end date is 15 days from today
  2. Yellow - if the contract end date less than 15 days from today, and
  3. Red if the contract end date already expired from today

Thanks. :)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!