Populating more than one contact in a cell when there are multiple departments

jackie_t23

Hello,

I am trying a change control request log where the change affects multiple departments. I would like the corresponding Department managers to populate in the next column in one cell. i have a separate sheet that lists the departments (text) and the managers (contact list).

Adam Murphy

I would use and INDEX/MATCH formula to lookup the contacts in your separate sheet and list on your change request log sheet in a contacts column that is set to allow multiple contacts in a cell. Will that work?

Paul Newcome

You would need to use a JOIN/COLLECT combo with a HAS function to get the list. This will only output a text string though. The email addresses will not be usable as contacts for things like current user filters and automations. Once you generate the string of email addresses based on the managers, you would need to use one of the methods outlined below to automate converting them into usable contacts, or you would need to manually do this.

https://community.smartsheet.com/discussion/123433/combine-emails-into-a-multiple-contact-column-multi-contact-column

jackie_t23

Thanks Everyone! I will look into these and potentially abandon the concept and try it from a different approach