Merging 2 Fields into a Formula-Text Field for Reporting Purposes

You can concatenate two fields together using the List function. 

 for example

List(", ", [Application Status - Primary], [Application Status - Secondary]);

That will separate the values (if both a re present) with a comma space.

Hi Mark:

Thank you for your quick reply. I appreciate it. 

I should have shared that I have Application Status - Primary and Secondary fields for many programs. Let's say the program name is Nursing. How would I include the program name in the formula you created?

List(", ", [Application Status - Primary], [Application Status - Secondary]);

Thank you,

Roula

np,

[Program Name] & ": ", 

& 

List(", ",

IF([Application Status - Primary] <> "",  "Primary " & [Application Status - Primary],

IF([Application Status - Secondary] <> "",  "Secondary " & [Application Status - Secondary]))

Note that the separator can be any string including a vertical line feed. For example perhaps you want a vertical look and maybe you want  some bolding like this: (sorry the vertical spacing is too big on this Forum.

Nursing:

Primary: Wait listed

Secondary: Accepted

If you like you can give the exact format of how you want the results to appear and we can come up with a formula for that. 

Hi Mark:

Thank you. I am getting ready to leave for the day, and I am off on Friday. 

I will provide more detail on Monday morning so you can help me with the exact formula.

Thank you,

Roula Habbal