Skip to main content
Imtiyaz Chougle 님이 #Data Management에 질문했습니다
Is it possible to do multiple indepdent if conditions in formula field. I need to calculate a numeric field based on multiple other fields. Here is what it looks like:

 

if field1 = "WA" add 1 to numericField;

 

if field2 = "CA" add 1 to numericField;

 

At the end of this, the numericField can either be 0, 1 or 2. Can this be done?
답변 2개
  1. 2017년 7월 25일 오전 12:07
    Try this.

     

    If (field1__c = "WA", 1, 0) +

     

    If (field2__c = "CA", 1, 0)