Concatenate fields with an IF statement

Question

Hello,

I need help with a formula. I am trying to concatenate two fields and also add an IF statement.

It doesn't seem to be working. This is what I have so far:

Name&"" &RecordType.Name& ""&

(IF(NOT(ISBLANK(Report_Date__c)), Report_Date__c, TODAY())

Deepak K Anand · Accepted Answer

Try this = Name + "-" + RecordType.Name + "-" + TEXT(BLANKVALUE(Report_Date__c, TODAY()))

Ahilesh Ragavan Radhakrishnan · Answer

++  If you need the date in MM/DD/YYYY then try this: Name&" "&RecordType.Name&" "& IF(NOT(ISBLANK(Report_Date__c)),​​​​TEXT(MONTH(Report_Date__c))&"/"&TEXT(DAY(Report_Date__c))&"/"&TEXT(YEAR(Report_Date__c)), TEXT(MONTH(TODAY()))&"/"&TEXT(DAY(TODAY()))&"/"&TEXT(YEAR(TODAY())))

Concatenate fields with an IF statement

Data Management

Related Learning

More Help