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 réponses
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 "(" ;)