IF (
NOT ( ISBLANK ( SFDC_Administrator__c ) ) ,
"SFDC Admin" & BR() & ,
""
) &
IF (
NOT ( ISBLANK ( SFDC_Advanced_Administrator__c ) ) ,
"SFDC Advanced Admin" & BR() & ,
""
) &
IF (
NOT ( ISBLANK ( SFDC_Consultant__c ) ) ,
"SFDC Consultant" & BR() & ,
""
) &
IF (
NOT ( ISBLANK ( SFDC_Sales_Cloud_Consultant__c ) ) ,
"SFDC Sales Cloud Consultant" & BR() & ,
""
) &
IF (
NOT ( ISBLANK ( SFDC_Service_Cloud_Consultant__c ) ) ,
"SFDC Service Cloud Consultant" & BR() & ,
""
) &
IF (
NOT ( ISBLANK ( SFDC_Developer__c ) ) ,
"SFDC Developer" & BR() & ,
""
) &
IF (
NOT ( ISBLANK ( SFDC_Advanced_Developer_Exam_Only__c ) ) ,
"SFDC Advanced Developer - Exam Only" & BR() & ,
""
) &
IF (
NOT ( ISBLANK ( SFDC_Advanced_Developer__c ) ) ,
"SFDC Advanced Developer" & BR() & ,
""
) &
IF (
NOT ( ISBLANK ( Technical_Architect__c ) ) ,
"Technical Architect" & BR() & ,
""
)
I think you need something like this => IF( SFDC_Administrator__c = TRUE ,"SFDC Admin" + BR() , NULL) +
IF( SFDC_Advanced_Administrator__c = TRUE ,"SFDC Advanced Admin" + BR() , NULL) +
IF( SFDC_Consultant__c = TRUE , "SFDC Consultant" + BR() , NULL) +
IF( SFDC_Sales_Cloud_Consultant__c = TRUE ,"SFDC Sales Cloud Consultant" + BR(), NULL) +
IF( SFDC_Service_Cloud_Consultant__c = TRUE ,"SFDC Service Cloud Consultant" + BR() , NULL) +
IF( SFDC_Developer__c = TRUE ,"SFDC Developer" + BR() , NULL) +
IF( SFDC_Advanced_Developer_Exam_Only__c = TRUE, "SFDC Advanced Developer - Exam Only" + BR() , NULL) +
IF( SFDC_Advanced_Developer__c = TRUE ,"SFDC Advanced Developer" + BR() , NULL) +
IF( Technical_Architect__c = TRUE , "Technical Architect" , NULL)
