Is it possible to cross reference contact columns in different sheets?

Allison Mandelkow1

Hello,

I have two different sheets (in different Workspaces) that I am wondering if I can cross reference.

For instance, I have a sheet with a 'Developer Contact' column whose column type is a contact list. I also have a sheet with a 'Developer' column whose column type is a contact list. Wondering if I can set something up where when a 'Developer Contact' name is entered, it would look at the sheet with the 'Developer' column and if that name was not already in there, it would add the name into the sheet?

markkrebs

So you want to send new unique contact values to another sheet correct? Is this so you have a master list of developer contacts?

Do you own datamesh by chance? If not this can be done with a helper column and some automation.

Allison Mandelkow1

Yes that is correct. We want the sheet with the 'Developer' column to be a master list of developer contacts! We do not have a license for datamesh at this time.