Skip to main content

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

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


Reply