Skip to main content
Topics#Data ManagementMinky Hyun의 질문
Minky Hyun 님이 #Data Management에 질문했습니다
2017년 5월 15일 오후 9: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개
  1. Sunil Sarilla (M&G Investments)
    2017년 5월 15일 오후 9: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.
답변을 작성하세요...
0/9000