Merge contact columns for dynamic view


Hello all,

I'm looking to create a dynamic view in which two contact columns can be selected. Aka, folks need to see their content if their name is listed in either contact column A (primary champion) or contact column B (secondary champion). Is there a workaround for this? I am only seeing the option to select one column in the "restrict view by user field." I attempted to create a third column and use a basic formula: = contact column A + contact column B, but it didn't seem to be able to copy the contacts over, it just copied the names themselves. Any help is appreciated!


  • Denden8706

    The only way I have been successful with this is by creating a hierarchy on your sheet by indenting rows. When you indent a row, it becomes a child of the row above it (the parent row).

    Hope this helps.