lkolmer
Novice

Validation Rule To Make Another Column Required

Jump to solution

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

0 Kudos
Reply
1 Reply
Chris_Ben
Scout

Re: Validation Rule To Make Another Column Required

Jump to solution

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

View solution in original post

Reply