9 Replies Latest reply: Mar 20, 2015 3:27 PM by Sunny Talwar RSS

    conditional concat

    Todd Kaiser

      I have the attached spreadsheet with the data that I would like to return.

      milestone activity comment
      1 painting the room covered all the furniture
      1 painting the room taped off the windows
      1 painting the room primed the walls
      1 painting the room painted the walls

      I believe the correct solution is to create the script upon the load, but wasn't sure.  The milestone is the same as well as the activity, but the update comments get appended at some frequency.  My intention is to join based on the activity and then have a "grouped" comment variable/argument that would contain all the comments relating to that activity.  This would in theory have a list box with one line with all the comments concatenated rather than currently they are separate items.