# Red, Yellow and Green Countdown forumula

Options

I would like to add Red, Yellow and Green to help visualize how many days until the event has been closed.

• ✭✭✭✭✭
Options

You could create a formula that would look at two date fields and conditional render a status next to the field that you want to highlight as shown above.

Something like if Field B - Field A < 35, red

Ryan

• Options

I already have a formula under Closed date:

= [Closed Date] - [End Date] <35, red

• Options

Trying to have a red, yellow or green symbol in the middle column. Is this possible?

• ✭✭✭✭✭
Options

Of course it is. Just make the column of type symbol and then add your if statements.

If you're stuck, just share the grid with me - ryan@dynamicduo.io

Ryan

• ✭✭✭✭✭✭
Options

Try something like this...

=IF(AND(TODAY() <= [Closed Date (35 days after End Date]@row, TODAY() >= [Closed Date (35 days after End Date]@row - 5), "Red", IF(AND(TODAY() <= [Closed Date (35 days after End Date]@row - 10, TODAY() >= [Closed Date (35 days after End Date]@row - 20), "Yellow", IF(AND(TODAY() <= [Closed Date (35 days after End Date]@row - 21, TODAY() >= [Closed Date (35 days after End Date]@row - 34), "Green")))

• Options

I must be missing a step. I copied Paul's formula above and it did not work. Any suggestions?

• ✭✭✭✭✭
Options

It can be difficult to debug it this way. I would take the first IF condition and then verify that works, and add them on sequentially.

Ryan

• Options

That worked @Ryan Kramer . Thank you bunches. I have a meeting in 15 minutes and was hoping to show this formula with the presentation.

• ✭✭✭✭✭✭
Options

Glad you were able to get it working. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!