Discussions
Saved search that shows employees and all of their roles on one line
I have a saved search that lists all of the employees, but it lists each employee and then each role on separate lines. I would like to show all of the roles on one line.
I found this same question and an answer from 2019, but the result doesn't work for me. I created a Formula (text), summary = minimum, Formula = LISTAGG({role],',')
when I run that it just shows a list of roles, it doesn't show the employee name, even though I have the name field in my results.