Populating Contacts to a Single Cell on a Different Sheet


Hi, I'm trying to figure out a way to have contacts from two separate cells on a resource sheet, to populate in a single cell on my work sheet. In trying to figure this out I found this resource in the forums:

The functionality of being able to retain the "Contact" when populating in a single cell is what I'm going for, however what I'm looking for is this to be automated and not need the end user to make a selection. Basically I'm trying to cell link multiple source cells into a single cell, in a Contact Column, on a work sheet, while maintaining the contact, and not having the output be text only. Has anyone had any success with this? Any help would be appreciated. Thanks


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!