Merge contact columns for dynamic view

haythom

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!

Smartsheet Case.png

Smartsheet Case2.png

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.