Assign multiple people to a row, based on multi select drop down.

mccoy_FSI ✭✭✭✭✭
edited 06/26/23 in Smartsheet Basics


I have a dropdown where the user can select multiple customers. I need to assign the person or people responsible for the customers selected. I have a customer list sheet and each row is a customer, the customer managers I am trying to pull in are on this sheet. So I need the formula to look at all the customers selected, and pull in all the customer managers required based on the customer list sheet. I know index/match can't do it. Not sure if I need to use join/collect or something else? But I can't seem to get it to work. Entering each customer on a separate form is not an option, the user might select 50 customers, so I can't have them entering 50 forms. I need to automatically pull in the customer managers responsible for those customers.