Traffic Light Conditional

Eberto Pallares

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. :)

Paul Newcome

Try this...

=IF([Contract End Date]@row < TODAY(), "Red", IF([Contract End Date]@row < TODAY(15), "Yellow", "Green"))