高章伟
2024-03-22 fca55b28dae5a6f847921c124878695e57b8164a
1
2
3
4
5
6
7
8
9
IF(OR(Change_To_Opportunity__r.SAP_Send_OK__c, NOT(ISBLANK(Change_To_Opportunity__r.NotesApprovedNo__c)),TEXT(Change_To_Opportunity__r.ConfirmationofAward__c ) == 'OLY中标',TEXT(Change_To_Opportunity__r.Opportunity_stage__c ) == '中标签约'),'A1',
    IF(TEXT(Change_To_Opportunity__r.Opportunity_stage__c) == '确定了OLY参数','A',
IF(TEXT(Change_To_Opportunity__r.Opportunity_stage__c) == '确定了OLY参数','A',
        IF(OR(Change_To_Opportunity__r.ImportDemonstration_state__c == '已批准', NOT(ISBLANK(Change_To_Opportunity__r.Authorized_DB_No__c)), TEXT(Change_To_Opportunity__r.Opportunity_stage__c ) == '没有确定参数'),'B',
            IF(OR(AND(NOT(ISBLANK(Change_To_Opportunity__r.Bidding_Project_Name_Bid__c)),Change_To_Opportunity__r.InfoTypeBid__c != '1:预告'),TEXT(Change_To_Opportunity__r.Opportunity_stage__c ) == '确定了对手参数',TEXT(Change_To_Opportunity__r.Opportunity_stage__c ) == '预算已经批准'),'C','G'
            )
        )
    )
)