Skip to main content
Hi All, 

 

I have created the formula field for the below requirments  for the 

 

Record type :

 

Occupied , Renewals

 

Conditions for: SLA Met

 

IF

 

a. ) All of the below are NOT blank: 

 

Days_to_Audit 

 

Days_to_Raw_Data 

 

Days_to_Audit_Report

 

AND

 

b.) All of the above added together are less than or equal to 57 THEN this should be SLA Met

 

Conditions for: On Track to Meet SLA

 

IF

 

a.) At least one, or more of the below are blank:

 

Days_to_Audit 

 

Days_to_Raw_Data 

 

Days_to_Audit_Report

 

AND b.) None of these individually, OR added together are greater than 57 THEN it should be On Track to Meet SLA

 

Conditions for: SLA NOT Met

 

IF

 

a.) Any one of the below individually OR added together are greater than 57 

 

Days_to_Audit 

 

Days_to_Raw_Data 

 

Days_to_Audit_Report

 

THEN it should be SLA NOT Met

 

Formula :

 

IF( 

 

OR( 

 

        RecordType.DeveloperName == 'Occupied', 

 

        RecordType.DeveloperName == 'Renewal'

 

        ),

 

AND((ISBLANK(Days_to_Audit__c),(ISBLANK(Days_to_Raw_Data__c),(ISBLANK(Days_to_Audit_Report__c),((Days_to_Audit__c + Days_to_Raw_Data__c + Days_to_Audit_Report__c )< 57), OR((Days_to_Audit__c <57),(Days_to_Raw_Data__c <57),(Days_to_Audit_Report__c <57))), 

 

        

 

"On track to meet SLA", 

 

IF(OR( 

 

        RecordType.DeveloperName == 'Occupied', 

 

        RecordType.DeveloperName == 'Renewal'

 

        ),

 

 AND( NOT(ISBLANK(Days_to_Audit__c)), NOT( ISBLANK(Days_to_Raw_Data__c)), NOT( ISBLANK(Days_to_Audit_Report__c)),((Days_to_Audit__c + Days_to_Raw_Data__c + Days_to_Audit_Report__c) < 57)), 

 

"SLA met", 

 

"SLA not met"))

 

I get the error : Error: Syntax error. Missing ')' ,Can some one please help me review with this formula field

 

 
8 answers
  1. Mar 10, 2021, 5:21 PM
    Hi Padmashree,

     

    I'm not an expert on formulas but what about the "(" in front of the "ISBLANK"s on line 6 of your fomula?

     

    To me it looks like you have copied the "SLA met" formula, deleted the "NOT" but not the starting "(" ;)