Formula with symbols when a cell is NOT blank


HI Everyone, I´m looking for help with the following situation. I want My "Closed within due date" column to show:

Gray when the case has not been closed yet (and therefore Closed date is blank)

Green when Closed date is equal or less than Due date

Red when Closed date is higher than Due date.

I cant figure out the par for the gray. Here is what I have so far, but its marking as green (Closed within due date) all the cases that have not been closed yet:

=IF([End Date]@row < [Due date]@row, "Green", IF([End Date]@row = [Due date]@row, "Green", IF([End Date]@row > [Due date]@row, "Red")))

I was trying to use =IF(NOT(ISBLANK somewhere in the formula but I cant get it to work.

Thanks a lot!!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!