Conditional Statement with multiple conditions

[shelbybradley]

I am trying to write a statement that basically means If x AND y AND z AND e = "Yes", then "True" else "False". 

 Above is a set of data I am working with. In the Complete Fulfillment column, I want to capture a True or False for if each row in all the columns labeled "fulfilled" are Yes. For example, Week 1 would be a True and Week 2 would be a False.

Any suggestions on how to format that statement in Alteryx?

[atcodedog05 · Accepted solution]

Hi @shelbybradley 

Here is how you can do it.

Workflow:

Hope this helps : )

[Hamder83]

Hi 

If the requirement is all 3 beeing yes, for complete to be Yes.

Could you not just use, 
IF A,B,C = True
THEN
True
ELSE 
False?

Endif?

[atcodedog05]

Hi @Hamder83 

No, it doesnt work that way sadly.

[atcodedog05]

Happy to help : ) @shelbybradley 

Cheers and have a nice day!