IF Field Not Null Display A Else Concatenate B, C, D

Topic Labels: Formulas
777 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

My goal is to have a formula to populate New Profile from either Legacy Profile or a Concatenate of Company Responsibility, Professional Background, Educational Background. Ideally for the Concatenate portion, I can have the three fields with a paragraph break between them, if that level of formatting can be achieved. (as demonstrated in the sample table below)

My records will only have either the legacy field or the new 3-field combo populated with data.

New Profile fx Legacy Profile Company Responsbility Professional Background Educational Background
Amazing legacy profile Amazing legacy profile
CEO responsible for big things.Worked at great companies like…Super smart because they went to the University of Smartness. CEO responsible for big things. Worked at great companies like… Super smart because they went to the University of Smartness.

Thanks for the assistance.

1 Reply 1
10 - Mercury
10 - Mercury

Hi there!

Try this :slightly_smiling_face:

IF({Legacy Profile}, {Legacy Profile}, {Company Responsibility} & " " & {Professional Background} & " " & {Educational Background})

Hope that helps!