Skip to main content
Topics#Data ManagementPergunta de Ana Rottaro
Ana Rottaro perguntou em #Data Management
18 de jun. de 2019, 15:25

Contains in If formula not working

I'm creating a checkbox field that takes a formula.  It worked for everything except accounts with close in the Name that now sometimes are checked an other times are not, however I want them to not be checked at all.  An example of an account name with closed in the title is "CLOSED Tenessee Academy"

 

If(contains(Name, "CLOSED")==false && (ISPICKVAL(Category__c, 'K-12, Charter') || ISPICKVAL(Category__c ,'K-12, Private')) && (X2019_Avg_Monthly_Views__c  >= 50 || (Total_Students__c  >=50 && isblank(Metro_Area__c) == false) || Niche_Grade__c == 'A-' || Niche_Grade__c == 'A' || Niche_Grade__c == 'A+'), TRUE, 

 

IF((Magnet__c == true && X2019_Avg_Monthly_Views__c >= 50 && contains(Name, "CLOSED")== false), TRUE,

 

IF((ISPICKVAL(Category__c, 'College, Traditional')|| ISPICKVAL(Category__c, 'College, Career') || ISPICKVAL(Category__c,'College, International') || ISPICKVAL(Category__c,'District')) && X2019_Avg_Monthly_Views__c >= 200 && contains(Name, "CLOSED")== false, true, 

 

IF(ISPICKVAL(Reporting_Type__c, '4 year college') && Total_Students__c >100 && contains(Name, 'CLOSED')== false, true, 

 

IF(ISPICKVAL(Reporting_Type__c, '2 year college') && (Total_Students__c >50 ||  isblank(Metro_Area__c) = false) && contains(Name, "CLOSED")== false, true, 

 

IF(ISPICKVAL(Category__c, 'K-12, District') && Total_Students__c >= 500, true, 

 

If(ISPICKVAL(Type, 'Private, Boarding') && contains(Name, "CLOSED")== false, true, 

 

if(TABS_School__c  == TRUE && contains(Name, "CLOSED")== false, true, 

 

if(ISPICKVAL(Category__c, 'College, Placeholder') && contains(Name, "CLOSED")== false, true, 

 

if(ISPICKVAL(Reporting_Type__c, 'K-12 Network') && contains(Name, "CLOSED")== false, true, 

 

if(NAIS_School__c == True && contains(Name, "CLOSED")== false, true, 

 

if(NCEA__c  == TRUE && contains(Name, "CLOSED")== false, True,   

 

False))))))))))))

 

 
7 respostas
  1. Ana Rottaro
    19 de jun. de 2019, 17:01
    The formula was over 2,000 characters and so Salesforce had trouble updating my report and lagged all together for each account.  I changed the formula to b shorter, which solved the problem. 
Escrever uma resposta...
0/9000