SharePoint List - Concatenate multiple rows
Hello! Thank you so much for any assistance, truly. I am hoping to create a SharePoint calculated column. I have a SharePoint list In which I display agent's leads. Within the list, it shows the lead, the agent assigned, and which region the lead is assigned to; moreover, I want to create a calculated column that will be next to the my agent assigned column that will display the name of the different region choices they are assigned to. So, if an agent is assigned to multiple, different, regions, it will display such (even if they are viewing only one of their leads). If I need to make a calculated column, I can group the agents based on their email column.