If / Then using the red, yellow, green
I am new to Smartsheets, so this may be a basic knowledge question ...
I'm trying to use the red, yellow, green, (really just red and green) for the following scenario ...
Start date is 10/1/20, due date is 10/6/20, another column for completed date.
Using the completed date if it is <due date, then green, if it is finish date, then red. Here is what I have . The green works, but I can't get the red to display.
=IF(Completed7 < Due7, "Green"), IF(Completed7 > Due7, "Red")
Thank you in advance !