Logic operators in formulas

Ask for Help
1

I have two formula fields that checks the fields “Status” and “End Dates”. This formula works fine:
IF(AND(Status <> “DONE”, End Date < TODAY()), “Yes”)

This one does not:
IF(AND(Status = “DONE” ,End Date < TODAY()), “Yes”)

The problem seems to be that the field changes to boolean while using the “=” operator. And I’m not allowed to change the field type (field is greyed out).

2

Hey @John could it be that you’re not providing a 3rd argument to IF ?

You could try recreating the formula in a new field (which will retype it)

IF(AND(Status = “DONE” ,End Date < TODAY()), “Yes”, "")
3

That’s got it. Thanks!