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개
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 "(" ;)