How to show blank when there is no date.

Options

I'm trying to have the drop-down show "LATE" when date in "Estimated Completion Date" Column is past TODAY & does not already have the drop down chosen. However, if there is no date, I'd like the drop-down to remain blank.

All the help is much appreciated!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!