Color Auto-Changes

edited 12/09/19 in Formulas and Functions

I have my sheet coded so that the status updates as the due date approaches, passes, etc. The only problem is that in a row where the due date is blank it considers it 'Late' and makes it red.  I would like for it to just leave the status blank in that row.  This is the formula I had used:

=IF([Date Due]3 < TODAY(), "Red", IF([Date Due]3 = TODAY(), "Yellow", IF(TODAY() - [Date Due]3 > -3, "Yellow", IF([Date Due]3 > TODAY(), "Green"))))

Does anybody know what I should add to the line to make what I want happen?

Screen Shot 2018-06-11 at 12.09.56 PM.png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!