ctoper11
Cloud Wanderer

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

Jump to solution

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

0 Kudos
Reply
4 Replies
kunalpatel
Automation Master
Automation Master

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

Jump to solution

@ctoper11 try below formula in validation rule:

 

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

View solution in original post

Reply
claudiaurbanski
Process Pupil

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

Jump to solution

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

 

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

Reply
ctoper11
Cloud Wanderer

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

Jump to solution
@kunalpatel this did work I just replaced greaterThan with lessThanOrEqual
0 Kudos
Reply
ctoper11
Cloud Wanderer

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

Jump to solution
@claudiaurbanski 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"
0 Kudos
Reply