+2
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?
+6
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.
+2
Perfect, it worked!! Thanks!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.