Skip to main content
Nintex Community Menu Bar

I have a boolean Yes/No hiding a panel with three controls. One of them is a number column with a default of 0. I'm trying to have that column required if the boolean is Yes and the number column still has a zero in rather than any other number. I have below but it's not working. As always thanks you to everyone for your help.

 

contains(Yes/No Column, "true") && not(Hours, "0")

@ctoper11 try below formula in validation rule:



 



and(greaterThan(Title,"0"), equals(YesNo, True))


@ctoper11  boolean is Yes and the number column still has a zero:



 



=Yes/No Column&&Hours=="0"


@kunalpatel this did work I just replaced greaterThan with lessThanOrEqual
@Nunezma this looks simpler but it does not seem to be working the Yes/No Column name is actually =A3R3 so my formula looks like below. That look correct?

=A3R3&&H3=="0"

Reply