How do I create a lead validation formula to ensure at least one in a series of

Question

Hi There

Need some help in trying to create a lead validation rule.

I have a series of checkboxes (service types). I need to ensure that at least one of these boxes is ticked before the lead can be saved. What does this formula look like?

Linus Andersson · Accepted Answer

Hi Courtney,

Try something like this:

NOT(OR(ServiceType1__c, ServiceType2__c, ...))

Another option would be,

IF(ServiceType1__c = TRUE || ServiceType2__c = TRUE, TRUE, FALSE)

And use as many OR (||) as you have checkboxes.

//Linus

Courtney Cousins · Answer

Thanks Linus - the first formula suggestion worked perfectly.

How do I create a lead validation formula to ensure at least one in a series of

Data Management

Related Learning

More Help