Forum Discussion
MarkShnier__You
24 hours agoQrew Legend
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.