cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Formula to require when yes/no checkbox true and require empty when false

Jump to solution

I have a yes/no checkbox that is defaulted to No when new (Occupied). I have a people picker for the user name. I found a formula to require the people picker, which I applied to the Name field if yes which translates to true.  The one below works for that piece. 

and(Occupied==true, isNullorEmpty({self}))

Can I add an OR statement to ensure the people picker is empty if No?

 

Labels: (1)
Tags (1)
0 Kudos
Reply
2 Replies
Highlighted
Nintex Newbie

Re: Formula to require when yes/no checkbox true and require empty when false

Jump to solution

Hi.

 

I think this what you're looking to do

(Occupied == true && {self} == "") || (Occupied == false && {self} != "")

This is a validation rule.  If it evaluates true, it will fail validation.

Hope this helps.

Reply
Highlighted
Nintex Newbie

Re: Formula to require when yes/no checkbox true and require empty when false

Jump to solution

Perfect, it worked!! Thanks!

View solution in original post

0 Kudos
Reply