I need help with an If formula
The formula I'm using now, for annual certification is "If(IsNull([Next Certification Due Date]),"No","Yes") in a Formula Text field named Certified?. It works OK, but I want to mark Certification Du...
Forum Discussion
try this
IF(
IsNull([Next Certification Due Date]),"No",
[Next Certification Due Date] >= Today(), "No",
"Yes")
IF(
IsNull([Next Certification Due Date]),"No",
[Next Certification Due Date] >= Today(), "No",
"Yes")