How do I pull in two contacts into a specific cell?
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!
Help Article Resources
Check out the Formula Handbook template!