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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!