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
Check out the Formula Handbook template!