Formula for Changing Symbols

Options

I am trying to create a formula where the symbols (red, yellow and green circles) change when red when it is passed the Extension Deadline date, yellow when it is 60 days from the date, and green when it is more than 60 days from the date. What is a formula I can use to achieve this?

As of right now this is the formula I have: =IF([Extension Submittal Deadline]@row < 60, "Red", IF(AND([Extension Submittal Deadline]@row > 60, [Extension Submittal Deadline]@row = 60), "Yellow", [Extension Submittal Deadline]@row > 60, "Green"))

But it only shows red for all the other rows under 60 day notice.



Answers

  • Maaik Meijerink
    Maaik Meijerink ✭✭✭✭✭
    Options

    @J_Meyer,


    In your current formula you are comparing the value 60 with the value of the date, which makes no sense: You will have to use the TODAY function in combination with your date column:

    ... [Extension Submittal Deadline]@row - TODAY() < 60 ... if you want to compare today's date with the specified date and see if it has passed 60 days from now.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!