1 2 Previous Next 17 Replies Latest reply on Apr 24, 2018 9:53 AM by Ryan F

    How to concatenate when multiple values meet criteria

    Ryan F

      Hi,

       

      I have a calendar and I am trying to show all the meetings for the specific day as one long text.

      on the right I have the employee name and on the columns, I have the date. How do I get the meeting to concatenate into one long text if it meets the specific criteria?

      Sorry I can not share the data but below is a sample

       

      Header 1April 1stApril 2nd

      Employee 1

      company1company2company3
      Employee 2company1
      Employee 3
        1 2 Previous Next