IF > TODAY formula not working

I've been trying for hours to get this formula right and I think I've tried every combination.

I have a date field. It can either

  • Have a date
  • Be Blank
  • Have TBD
  • Have N/A

If it has a date AND the date greater than today OR if blank OR if it's TBD = not check

If N/A OR date is passed OR it's blank = checked

This is what I have currently - and with the field blank it's checking the box. If I have N/A its giving me Invalid Operation

=IF(OR([Gate 3]@row = "N/A", [Gate 3]@row < TODAY()), 1, 0)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!