Multiselect Dropdown Parsing

Allen M Vance

Hello all,

I have 3 columns in a sheet. 1 is a multi-select dropdown ("MSD"), 1 is a single contact ("SC"), and 1 is a multi-select contact ("MSC"). In the SC, I want to take the first dropdown value from the MSD and use it to index match a value from another sheet. In the MSC, then I want to take the remaining values from the MSD and index match those values individually from another sheet. I don't foresee more than 3 values in the MSD. Is this possible?

Paul Newcome

Technically yes. You can pull these values in based on the multi-select dropdown, but...

We cannot currently use formulas to populate multiple USABLE contacts in a single cell even if the column is set to allow multiple. It will simply generate a text string and won't be usable in automations for notifications, update requests, etc..

Paul Newcome

Technically yes. You can pull these values in based on the multi-select dropdown, but...

We cannot currently use formulas to populate multiple USABLE contacts in a single cell even if the column is set to allow multiple. It will simply generate a text string and won't be usable in automations for notifications, update requests, etc..