Solved

Making field required based on Yes/No the other based on number field

C
Badge +8

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")

icon

Best answer by kunalpatel 6 May 2021, 05:19

View original

4 replies

K
Badge +12

@ctoper11 try below formula in validation rule:


 


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

N
Badge +11

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


 


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

C
Badge +8
@kunalpatel this did work I just replaced greaterThan with lessThanOrEqual
C
Badge +8
@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


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings