Hello!
I’m creating a nintex form in sharepoint.
im trying to combine multiple if statements to return a value if true. For example if value 1 equals true, value 2 equals true, and value 3 equals true, return “complete”.
I’m having a hard time getting the formula to work.
Either it returns nothing or sometime it only requires two of the values to be true to return complete.
can someone explain proper way to combine multiple of statements?
Hi
I tested this formula using Yes/No controls, which behaved as expected.
If((Value1==true&&Value2==true&&Value3==true),"Complete","Not Complete")
Thank you! I didn’t know about the “&&”signs.
im glad I found this community! I’m still new to using nintex and have been spending so much time trying to figure things out on my own. So having people that can help now is great!
You can use “and()” and “equals()” runtime functions instead of @@ and ==, but the formula gets long, messy, and complicated.
It would look something like: (not tested)
If((and(equals(Value1,true),(and(equals(Value2,true),equals(Value3,true))))),”Complete”,”Not Complete”)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.