Forum Discussion

RoulaHabbal's avatar
RoulaHabbal
Qrew Cadet
2 months ago

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

Hello:

I have two fields that I want to merge for reporting purposes.

  • Application Status - Primary
  • Application Status - Secondary

I created a formula-text field named, Merge Primary/Secondary Application Status. 

I tried the formulas below, but none are working. Could someone assist me with tweaking any of my formulas, please?

First Try

If([Nursing]="",[Application Status - Primary Program],[Application Status - Secondary Program])

Second Try

If(
[Nursing]="Application Status - Primary Program",
[Nursing]="Application Status - Secondary Program"
,
true,
false,
)

Thank you,

Roula

  • RoulaHabbal's avatar
    RoulaHabbal
    29 days ago

    Good morning, Mark.

    I tried coping and pasting my details into this window, but I received the error below. I later learned the error is due to using lists, numbers, bullets!

    Without organizing the data, it would be very difficult for anyone to follow.

    I will try to work with the formula you gave me already.

    Thank you,

    Roula

  • 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

    • RoulaHabbal's avatar
      RoulaHabbal
      Qrew Cadet

      Good morning, Mark.

      I tried coping and pasting my details into this window, but I received the error below. I later learned the error is due to using lists, numbers, bullets!

      Without organizing the data, it would be very difficult for anyone to follow.

      I will try to work with the formula you gave me already.

      Thank you,

      Roula