If Date is blank + past formula

I can't figure out why this would return a "yes" when the date cell is blank.

=IF([Date of Site Survey (Product)]@row = " ", " ", IF(TODAY() > [Date of Site Survey (Product)]@row, "yes", " "))

Intended logic/result -

If date cell is blank, then "blank" (this worked when I tried without the 2nd argument added)

If date is in the past, the "yes" - if not "no"

Please advise...thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!