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!
Answers
-
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.
