How do I pull in two contacts into a specific cell?

EmilyD

I am trying to write a formula to pull in a contact based on identifying role into an assigned to cell.

So where it says Regional Admin and Manager, I want to pull in both of those contacts based on what gets entered into the Assigned To cell.

I managed if it was a single contact by using =[Assigned To]@row

I had to drag that formula though into the cells that qualify.

It would be nice to write a formula that will grab what's true based on role. That might be too extensive though.

Appreciate any help I can get!

Paul Newcome

There is currently no easy way to populate multiple usable contacts into a single cell dynamically through a formula. You would have to create a reference table with all possible combinations and then reference that.

EmilyD

Thank you! It will work as is and maybe in the near future I can improve it with the reference table.

Happy Thanksgiving!