Cell-linking work around

nate.rogers

Is there anyway for me to use a formula that when the value selected in a multi-select column is "Admin", then give me all the values from the "Baseline Start Date" ?

I want the values (dates) to come back to my sheet lined up as their own cells/rows (vertically placed) in a column that i want.

Similar to how you would do the cell-linking? When i select multiple cells, link from other sheet, the select multiple cells again, then it comes back as is.

Thank you!

Paul Newcome

What is your end goal for this list?

nate.rogers

@Paul Newcome to not use cell-linking

Paul Newcome

I understand that much, but why are you wanting to create this list. What are you wanting to use it for?