Forum Discussion

JanaBaker's avatar
JanaBaker
Qrew Cadet
7 years ago

Nested If Formula Error: Expecting Boolean but found number

Hey everybody!  Can someone help me with the below formula?  I get the "expecting Boolean but found number" error at the end of the FIRST If statement.  If i change it to NULL, then the 2nd IF stateme...
Errors
Formulas and functions
AnnSwelgin's avatar
AnnSwelgin
Qrew Trainee
7 years ago
I am also getting this error.. The 1 in the formula is highlighted and it says "expecting boolean but found number":

If (Contains([Activity Type], "PDFA"), Contains([Activity Type], "PDAFA"), 1, null)

and based on the comments above I assume my null should be a 0?