nhaugen3
Nintex Newbie

Help with IF Statement for Checkbox / Calculate Value

Hey everyone. I am new to Nintex / Sharepoint design and am trying to create an IF statement for some checkboxes mapping to a calculated field but am not sure of the best approach. Here the checkboxes are shown and the condition I need is that if 'Member' is chosen (set to YES) then display the name 'John', if 'Provider' is set to YES then display 'Jane'.

 

checkboxes.PNG

Bit of a syntax novice.. Any help is much appreciated! Thanks!

0 Kudos
Reply
1 Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: Help with IF Statement for Checkbox / Calculate Value

Hi,

The issue here is what happens if both checkboxes are checked, what behavior do you want to see then?

I have attached a form with an example of what you want to acheive.

The issue is that if multiple checkboxs are checked the calculated value will display the first True statement it finds in the function.

or(If(Member,"John",""),If(Provider,"Jane",""))

In this case if both Member and Provider are checked then the calculated value will show John.

If only one is checked the respective output will show.

 

0 Kudos
Reply