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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Aside from the syntax error, it is an odd looking formula, can you explain in words what the logic is trying to do?
AnnSwelgin's avatar
AnnSwelgin
Qrew Trainee
7 years ago
I believe it would be true/false, so whether it has either of these activity types or not.

This is the original formula:
If(Contains([Activity Type],
"PDFA",1,
"PDAFA",1,
null)

I found this report someone else had created a few years ago and I am still learning what this table actually does.. I'll do some deeper digging and see if I can fix on my own or ask again.