Formula Help.

styless ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I have a formula going on for the RYG. I added a new column, "Status". I wanted it to be If the status column is FILLED or CANCELLED, the ball will turned Green and canceled out all the other formatting. How can I corporate that into the existing formula below?

=IF(TODAY() - [Date Opened]@row <= 60, "Green", IF(AND(TODAY() - [Date Opened]@row <= 124, TODAY() - [Date Opened]@row >= 61), "Yellow", "Red"))

Sample Sheet:


Thanks for the help!