Combining Contact Cell Contents

Paul Perger

I have three different columns on a sheet, each for different uses. But, I am creating a Dynamic View of that sheet and I want to make that Dynamic View available to contacts in each of those three columns.

I tried to combine those columns into one "Dynamic View" column via a formula that would obviously change when contacts in one of the three contact columns changed, but I keep getting simple text with every formula I try…

Is there a way to combine CONTACTS from multiple columns into a single column and maintain them as CONTACTS? (BTW, ALL of the columns are set up as Contact Columns.)

Paul Newcome

You would need to create a shared sheet filter that shows rows where at least one of them is "Current User", or you would create a report with the same filter applied