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"
Help Article Resources
Check out the Formula Handbook template!