結合時のカンマを除く数式

• Row Level Formulas

Opportunity.Renewal_Checks_Missing_Baseline__c& 
IF(ISBLANK(Opportunity.Renewal_Checks_Missing_Baseline__c),"",",") &
Opportunity.Renewal_Checks_Missing_Next_Steps__c&
IF(ISBLANK(Opportunity.Renewal_Checks_Missing_Next_Steps__c),"",",") &
Opportunity.Renewal_Checks_Missing_sub_type__c&
IF(ISBLANK(Opportunity.Renewal_Checks_Missing_sub_type__c),"",",") &
Opportunity.Renewal_Checks_Neg_ARR__c&
IF(ISBLANK(Opportunity.Renewal_Checks_Neg_ARR__c),"",",") &
Opportunity.Renewal_Checks_Stage_check__c

• Concatenate unique values in formula field

SUBSTITUTE( 
IF(ISBLANK(OTalks_Role_Last_Year__c), NULL, 
OTalks_Role_Last_Year__c + ', ') + 
IF(ISBLANK(OTalks_Role_2_Yrs_Ago__c ), NULL, 
OTalks_Role_2_Yrs_Ago__c  + ', ') + 
IF(ISBLANK(OTalks_Role_3_Yrs_Ago__c ), NULL, 
OTalks_Role_3_Yrs_Ago__c  + ', ') + 
IF(ISBLANK(OTalks_Role_4_Yrs_Ago__c ), NULL, 
OTalks_Role_4_Yrs_Ago__c  + ', ') + 
IF(ISBLANK(OTalks_Role_5_Yrs_Ago__c ), NULL, 
OTalks_Role_5_Yrs_Ago__c  + ', ')  
+ '.', ', .', NULL)