+2Hello!
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?
Best answer by SimonMuntz
Hi
I tested this formula using Yes/No controls, which behaved as expected.
If((Value1==true&&Value2==true&&Value3==true),"Complete","Not Complete")
+23Hi
I tested this formula using Yes/No controls, which behaved as expected.
If((Value1==true&&Value2==true&&Value3==true),"Complete","Not Complete")
+2Thank 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!
+23
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.