I have a picklist field Source, When the Source field value is 'Social' then the formula should Concatenate the value using 3 fields
field 1 = work start date - Date type,
field 2 = Emp number - Text Type,
field 3 = Absence - Text Type,

Tried to concatenate 3 fields, getting syntax error

    ISPICKVAL(Source__c, 'WorkDay'),
    Work_Start_Date__c + DS_Employee_Number__c + DS_Absence_Type__c,

1 Answer 1


Replace fields by API Name of your fields -

IF(ISPICKVAL(Source, 'Social'), TEXT(Work_Start_Date__c) & DS_Employee_Number__c & DS_Absence_Type__c, '')

The return type should be text. You have to use TEXT function to convert the Date into text.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.