Hello,

I hope someone can help?

I have an Error Check report which lists new records added within the last month that highlights any specific errors. The report, which looks something like the image below is grouped by Team and then by User.

What I would like to do, preferably in one of the Group Headers is to create a string/formula that concatenates the user names (email addresses), along with the managers email address (included in the raw data), with each name seperated by a semi-colon ready to use in an email address field. eg manager1@hopeful.com; Joe.bloggs@hopeful.com; Sally.sprout@hopeful.com

Any help would be much appreciated.

Kind regards

Paul