Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

Topic Labels: Formulas
429 1
Showing results for 
Search instead for 
Did you mean: 

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

Hi there!

Try this :slightly_smiling_face:

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

Hope that helps!