Skip to main content
Topics#Data ManagementPregunta de Minky Hyun
Minky Hyun ha preguntado en #Data Management
15 may 2017, 21:16

Validation Rule - How can I required at least a certain number of checkboxes to be checked

I'm relatively new to Validation Rules and need to add one where before an opportunity goes to the next stage "Next Stage", at least 3 out of 5 checkboxes are checked.  How do I do that?
2 respuestas
  1. Sunil Sarilla (M&G Investments)
    15 may 2017, 21:41
    Hi Minky,

     

    Please try the below, is the Next Stage an actual value that you have for the Stage field and assuming it is

    AND(
    TEXT(StageName) = 'Next Stage',
    (
    IF(Checkbox1__c ,1,0)+
    IF(Checkbox2__c ,1,0)+
    IF(Checkbox3__c ,1,0)+
    IF(Checkbox4__c ,1,0)+
    IF(Checkbox5__c ,1,0)
    ) < 3
    )

     

    Please use the insert field button to select the field API Names of checkbox fields.
Escribir una respuesta...
0/9000