Employee saved search, results formula to concat all assigned roles

AI generated answer (using internal Slack threads):

Based on the conversations, to concatenate all assigned roles in an Employee saved search, you can use a formula field with a CASE statement. Here's how you can do it: 1. Create a new Employee saved search. 2. In the Results tab, add a new field with the following settings: - Summary Type: Group - Field: Formula (Text) - Formula:

CASE WHEN {role} IS NOT NULL THEN {role} || ', ' ELSE '' END

- Label: Assigned Roles 3. In the Criteria tab, add a new field with the following settings: - Summary Type: Group - Field: Name 4. Run the search. This will return a list of employees along with a comma-separated list of their assigned roles. The

CASE

statement checks if the role is not null, and if it's not, it appends the role name followed by a comma and a space. If the role is null, it returns an empty string. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******