Conditional Statement

Hello.

What could be wrong with this conditional statement because when I run it, it returns INCOMPLETE even when all conditions are satisfied.

cond(#form/preliminaries/home_owners_and_local_leaders_trained = "Yes" and #form/preliminaries/Construction_crews_and_Vendors_Trained = "Yes" and #form/preliminaries/Cash_grant_transfer_forms_Signed_by_home_owners = "Yes" and #form/preliminaries/Price_negotiation_of_Labour_completed = "Yes" and #form/preliminaries/Price_negotiation_of_hardware_materials_completed = "Yes" and #form/preliminaries/Brick_mobilisation-Earth_preparation = "Yes", and#form/preliminaries/Brick_mobilisation-Completed = "Yes", "COMPLETED", "INCOMPLETE")

you probably need a 'yes' instead a "Yes"

Let me try that out.

Sorry. It still doesnt

try putting that statement in notepadd++ or something.

there seems to be an extra comma after earth preparation = yes.
if (condition, do when true, do all the other times)
you have if(condition, something, completed, incomplete)

it maybe should have thrown you a syntax error but then again when you copy and paste into the forum it doesn't always do it correctly.
if all fails, just try to use the condition editor for a display condition, then switch to advance editor, copy, paste into the calculate condition