+1
I have two columns, Column A which is a Yes/No checkbox, then Column B is a single line of text. If Column A is "Yes" then Column B is required.
Based on other threads that I've read I thought I came up with the correct validation rule.
isNullOrEmpty({Self}) && Column B=="Yes"
This isn't working. Are there other IDs or values I should be using instead of 'Yes', I also tried 'TRUE'. But that didn't work either. Are there any other settings I need to change?
Thanks,
Lauren
+12
Hi Lauren,
You're almost there! ;-) The yes/no checkbox is a Boolean value i.e. either 0 or 1. So if you change your formula to the following it will work. Oh yeah - I think you've also mistyped Column B in your example above. It should be Column A.
isNullOrEmpty({Self}) && Column A==1
Cheers,
Chris
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.