Contacts in a column from another sheet to a separate sheet

A.J. ✭✭✭✭✭✭

Hi, I was wondering if anybody has an idea on how to accomplish what I am trying to do.

I have a sheet where there is a column formatted as a contact list. There's approximately 100 rows, each with an entry of a particular person. Some people are duplicated in the row.

I have a separate sheet (for a different purpose). There too is a column for contacts, but each row would have different contacts. I am wanting to get the full range (including all contacts) from the one column to show in the single field on the second sheet.

The reason for wanting this is that my second sheet has automation in place that when a certain field is reached, all of of the contacts in that one particular cell are notified and who is pertinent to be notified is based on the first sheet.

Thanks in advance for any help you can give.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!