Replace/Substitute Multi Select Field Values with Values from Another Field

Hi Jess, I’ve put something together here for you that should do what you’re looking for

You can duplicate the base to view the formulas

The idea is we just use the following code for each email we need to display, replacing the variables where needed:

IF(
    AND(
      FIND(
        "Buyer", {Multi Select}
      ),
      {Buyer Email}
    ),
    {Buyer Email} & ","
  ) & 

I used a REGEX_REPLACE to get rid of the trailing comma and you can remove that if you want

Hi Jess, I’ve put something together here for you that should do what you’re looking for

You can duplicate the base to view the formulas

The idea is we just use the following code for each email we need to display, replacing the variables where needed:

IF(
    AND(
      FIND(
        "Buyer", {Multi Select}
      ),
      {Buyer Email}
    ),
    {Buyer Email} & ","
  ) & 

I used a REGEX_REPLACE to get rid of the trailing comma and you can remove that if you want

Hey Adam!

I am running into a couple snags.

1. The “Buyer” lookup field is multi select so when there is more than one buyer, it combines the email addresses with no comma. See image below.
   

2. For some reason it is adding the buyer emails in the CC field when the “Buyer” is not an option. See image below.
   

Any assistance you could give would be greatly appreciated!

Weird! Could I get a screenshot of the field(s) that contain the data buyerone@email.combuyeringtwo@email.com please? That’ll help me figure out what’s going on

Ah, yeah, that’s because the formula just looks for the word Buyer. Since the CC (from Email Templates) field contains Buyer Agent etc, and thus the word Buyer, it fulfils the condition and shows the buyer emails

I think the only way around this would be to make the text we’re looking for unique, so we would have to change Buyer to something that wouldn’t be found in your other options, maybe Buyer Primary, Buyer Client or some such

Hi Jess, thanks for the screenshots

For the missing comma thing, we’ll need to put an ARRAYJOIN() around the lookup field we’re displaying the emails from, so that it looks something like this:
ARRAYJOIN({Buyer Email (from Buyer)})

This should solve that issue I think

Ahh, understood. Hmm, we could modify the formula so that it looks like the following?

FIND(
    "Buyer,", {Multi Select} & ","
  ),

I’ve made the updates to the base linked above as well